RE: Name Parsing w/RPGLE

Perhaps some statistical analysis....   Compile a list of IDENTIFIABLE last
names, then locate all the rows that contain these names.  If common last
name is first word in the field, then classify as LFM (Last, First, Mi),
otherwise its FML.  If you wind up with a preponderance of results in one
grouping, then design your parser to default to this pattern.  Depending on
how many exception you saw, you might need to test for obvious exceptions
and override to the appropriate method....  The same list of common last
names could be used again to test at runtime...  

Chances are, you'll still have exceptions, but considering what you were
given........

Add to your common last names table as you see fit...

hth,

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of
michael@xxxxxxxxxxxxxxxxxx
Sent: Wednesday, January 11, 2006 1:21 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Name Parsing w/RPGLE


I put in James Rich and it came back with Firstname: James, Last Name:
Rich.

I put in Rich James and it came back with Firstname: Rich, Last Name:
James.

Ah...I could write this code.

> -------- Original Message --------
> Subject: Re: Name Parsing w/RPGLE
> From: jmajor@xxxxxxxxxxxxxxx
> Date: Wed, January 11, 2006 1:53 pm
> To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
> Cc: rpg400-l@xxxxxxxxxxxx, rpg400-l-bounces@xxxxxxxxxxxx
> 
> Thanks for all the responses however I have no control of what the vendor 
> is passing and they stated they will not change it...
> 
> I have written other parsers for names however its always Last, First and 
> sometimes a prefix or Sr/Jr...
> 
> Its actually funny because I have had staff that look at the files we get 
> from the vendor and can not determine the first and last name......  just 
> like James Rick....!
> 
> Well thanks for the comments I have seen some webservices available to do 
> this however would love to figure out how they are doing it....
> 
> Like this service...
> 
> http://www.serviceobjects.com/products/dots_namevalidation.asp
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.