Separate data in LastName, FirstName format

[Guest.Visitor]

Susan - Try the attached. (Assumes existence of a comma - some error handling should be added if none exists)

[nycsusan@hotmail.com]

After being away from RPG for FOUR (4) years, I need to use it again and I was hoping someone here could help. The client sent us "unformatted" data, to put it politely, and I have to programmatically clean up the file. One example is that there is only one NAME field, and it contains Lastname, Firstname together. I need to rifle through that file and pick off everything up to the comma and move it to a LASTNAME field in an output file, and the remainder will be moved to the FIRSTNAME field in an output file. Any suggestions on the easiest way to break apart the Lastname, Firstname data in the input file using RPG?

[nycsusan@hotmail.com]

Bill, This helped a lot!!! Thank you so much!!!