RE: First / Last name Parsing... routines.

Sounds like fun, but hard to generically code.

Here's my Sunday morning crossword puzzle solving mode partial solution:

You will need to analyze the source data.
1. Create a file with a key that matches the source file.
Add a field for the field in question.
Add fields for name1, name2, name3, name4, nameremain (to store any
remaining text in the source field)
Add a field that will be a code used to designate a name field data
attribute. (ex: 1 = First, mi, Last; 2 = First, Last; 3= Last, First; 4 =
Last, First, mi; etc. If the name field value is 'Wyle E. Coyote' then the
code assigned would be a 1. If the name is 'Foghorn Leghorn' then the code
to assign is 2. If the name is 'Droopy' then assign a code that designates
this is a first name only (or a last name). This part could be fun, yet
tedious)

2. Create a program to move the source file fields into the new file. Parse
out the field in question by looking for delimiters and loading name1,2,3 by
data found between delimiters.

3. Now analyze the data and using SQL or a file maintenance utility assign
the code to tell how to translate the name.
4. Write a program to take the data and load your target file or fields
based on the assigned code.

Paul


Paul Therrien
Andeco Software, LLC
932 Saint Johns Dr
Maryville, TN 37801
225-229-2491
paultherrien@xxxxxxxxxxxxxxxxxx
www.andecosoftware.com

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Hatzenbeler, Tim
Sent: Sunday, July 17, 2011 4:01 AM
To: 'RPG programming on the IBM i / System i'
Subject: First / Last name Parsing... routines.

Does anybody have a link or procedure they are willing to share?

I have a field that contains a name (ie: first mi last or first last or a
ton of every variation you can think of) But I need it broken out in 3
fields first mi lastname.

Any help would be appreciated.

Thanks, Tim

This e-mail message, including any attachments, is for the
sole use of the intended recipient(s) and may contain
confidential or privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.

Think Green! Please do not print this e-mail unless you need to. Thank you.