DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: REQ - name format changer  (Read 7,630 times)

agent23

  • Participant
  • Joined in 2009
  • *
  • Posts: 9
REQ - name format changer
« on: November 10, 2009, 07: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
    • Participated in NANY Challenge Once
Re: REQ - name format changer
« Reply #1 on: November 10, 2009, 07: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

  • Amateur Radio Guy
  • Charter Honorary Member
  • Joined in 2006
  • ***
  • Posts: 893
    • Plugin Coding Medal
    • Participated in NANY Challenge Fifteen Times
    • Cody Award
    • Coding Snacks
    • Volunteers/Staff
    • Hardware Hacker
Re: REQ - name format changer
« Reply #2 on: November 10, 2009, 07:53 PM »
Maybe try CSV file editor: http://csved.sjfrancke.nl/

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

skwire

  • I eat Coding Snacks for breakfast...
  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,297
    • Participated in NANY Challenge Seventeen Times
    • Coding Snacks
    • Superboy Coder
    • Cody Award
    • Volunteers/Staff
    • Gathering Badge
Re: REQ - name format changer
« Reply #3 on: November 10, 2009, 08: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
    • Gathering Badge
    • Coding Snacks
Re: REQ - name format changer
« Reply #4 on: November 10, 2009, 08:34 PM »
That was amazingly fast :)
Go Skwire!  :Thmbsup:

agent23

  • Participant
  • Joined in 2009
  • *
  • Posts: 9
Re: REQ - name format changer
« Reply #5 on: November 10, 2009, 08:50 PM »
works great, thanks

skwire

  • I eat Coding Snacks for breakfast...
  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,297
    • Participated in NANY Challenge Seventeen Times
    • Coding Snacks
    • Superboy Coder
    • Cody Award
    • Volunteers/Staff
    • Gathering Badge
Re: REQ - name format changer
« Reply #6 on: November 10, 2009, 08:59 PM »
Quote from: Gothi[c
link=topic=20575.msg184178#msg184178 date=1257885267]
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.

Original address: https://www.donationcoder.com/forum/index.php?topic=20575.0