topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday March 28, 2024, 10:58 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: REQ - name format changer  (Read 5232 times)

agent23

  • Participant
  • Joined in 2009
  • *
  • default avatar
  • Posts: 9
    • View Profile
    • Donate to Member
REQ - name format changer
« on: November 10, 2009, 01:36 PM »
program needed to change a long list of names written in Last, First format to First Last. it must be able to handle a list of at least 256 names.

e.g.
the list:
Smith, John
Jenkins, P.M.
Sanders, Jerry S.

gets changed to:
John Smith
P.M. Jenkins
Jerry S. Sanders

JavaJones

  • Review 2.0 Designer
  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,739
    • View Profile
    • Donate to Member
Re: REQ - name format changer
« Reply #1 on: November 10, 2009, 01:44 PM »
I reckon you might be able to do this with Excel (or OpenOffice Calc other spreadsheet app), particularly if all the names actually separated by commas or spaces already. If it's in a plain text file just load it as a CSV, specify the separator that works best to get the data into columns (it will show you a preview in the Calc importer from which you can judge). Then once you have it in columns, just switch the columns and save out to text file.

- Oshyan

hamradio

  • Charter Honorary Member
  • Joined in 2006
  • ***
  • Posts: 825
  • Amateur Radio Guy
    • View Profile
    • HamRadioUSA.net
    • Read more about this member.
    • Donate to Member
Re: REQ - name format changer
« Reply #2 on: November 10, 2009, 01:53 PM »
Maybe try CSV file editor: http://csved.sjfrancke.nl/

I have used it briefly before and it seems to do good. :)

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: REQ - name format changer
« Reply #3 on: November 10, 2009, 02:20 PM »
Here you go (source/binary included):  LastToFirst

Paste in your list and click the button.

Gothi[c]

  • DC Server Admin
  • Charter Honorary Member
  • Joined in 2006
  • ***
  • Posts: 873
    • View Profile
    • linkerror
    • Donate to Member
Re: REQ - name format changer
« Reply #4 on: November 10, 2009, 02:34 PM »
That was amazingly fast :)
Go Skwire!  :Thmbsup:

agent23

  • Participant
  • Joined in 2009
  • *
  • default avatar
  • Posts: 9
    • View Profile
    • Donate to Member
Re: REQ - name format changer
« Reply #5 on: November 10, 2009, 02:50 PM »
works great, thanks

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: REQ - name format changer
« Reply #6 on: November 10, 2009, 02:59 PM »
That was amazingly fast :)

Thanks, this sort of thing is insane-easy in AHK.  GUI and all.

works great, thanks

You're welcome.  Glad to help.