RE: Parsing Names

["Alan Campin" <Alan.Campin@xxxxxxxxxxxxxxxx>]

<snip>
I have just been tasked with taking Excel files that contain full names
- in
various formats - and I am to break them into first, middle and last.

Years ago I did a lot of this in Foxpro, but I haven't done that for
longer
than I can remember. So, I'm looking for something in RPG that could do
the
job.
</snip?

I have a service program that will tokenize a given string and allows
you to work with the individual pieces. Might work fine for what you are
doing.

TokenCount = STGF_Tokenize(Full_Name);
If STGF_GetToken(1) = 'some_value';

If STGF_GetTokenSize(1) = Some_Value;

String = STGF_GetToken(1);
 
Etc. 

Definitely would not recommend using %Scan unless you have a very small
number to parse. Will suck up CPU like a sponge.

Let me know if you are interested.