Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • December 10, 2016, 02:31:00 PM
  • Proudly celebrating 10 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 2733 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:54 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,717
    • View Profile
    • Donate to Member
Re: REQ - name format changer
« Reply #1 on: November 10, 2009, 01:44:36 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: 677
  • 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:17 PM »
Maybe try CSV file editor: http://csved.sjfrancke.nl/

I have used it briefly before and it seems to do good. :)
Carroll - HamRadioUSA.net

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,669
    • View Profile
    • Donate to Member
Re: REQ - name format changer
« Reply #3 on: November 10, 2009, 02:20:25 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: 858
    • View Profile
    • linkerror
    • Donate to Member
Re: REQ - name format changer
« Reply #4 on: November 10, 2009, 02:34:27 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:18 PM »
works great, thanks

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 4,669
    • View Profile
    • Donate to Member
Re: REQ - name format changer
« Reply #6 on: November 10, 2009, 02:59:18 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.