Welcome Guest.   Make a donation to an author on the site November 21, 2009, 06:36:46 AM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.

You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
Your Support Funds this Site: View the Supporter Yearbook.
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
+  DonationCoder.com Forum
|-+  DonationCoder.com Software
| |-+  Coding Snacks
| | |-+  Post New Requests Here
| | | |-+  REQ - name format changer
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: REQ - name format changer  (Read 305 times)
agent23
Participant
*
Posts: 9

View Profile Give some DonationCredits to this forum member
« 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
Logged
JavaJones
Review 2.0 Designer
Charter Member
***
Posts: 907


see users location on a map View Profile WWW Give some DonationCredits to this forum member
« 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
Logged
The New Adventures of Oshyan Greene - A life in pictures...
hamradio
FARR Core Alias Master
Charter Honorary Member
***
Posts: 334



Amateur Radio Guy

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« 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. smiley
Logged
Carroll - HamRadioUSA | screen res: 1680x1050 px | Color Depth: True Color (32 bit) | Font Size: 96 dpi
skwire
Charter Member
***
Posts: 805



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« 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.
Logged


[ Trout | Skwire Empire ]
Gothi[c]
DC Server Admin
Charter Honorary Member
***
Posts: 727



gnuisance

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #4 on: November 10, 2009, 02:34:27 PM »
That was amazingly fast smiley
Go Skwire!  Thmbsup
Logged
-> Click to see my DC software for basement (and attic) dwellers, and other geeky creatures. <-
-> Click if you are in need of server administration. <-
agent23
Participant
*
Posts: 9

View Profile Give some DonationCredits to this forum member
« Reply #5 on: November 10, 2009, 02:50:18 PM »
works great, thanks
Logged
skwire
Charter Member
***
Posts: 805



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #6 on: November 10, 2009, 02:59:18 PM »
Quote from: Gothi[c] on November 10, 2009, 02:34:27 PM
That was amazingly fast smiley

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

Quote from: agent23 on November 10, 2009, 02:50:18 PM
works great, thanks

You're welcome.  Glad to help.
Logged


[ Trout | Skwire Empire ]
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
SMF © 2006-2009, Simple Machines LLC

social bookmark this page