So I'm importing a file into a temp table using DBLoad.

This file though does not have the same format as the table it will
move into. It needs to be "Last, First M" but within the file it is
"First M Last". Not all people have middle initial as well, and if they
don't have a middle initial there are 2 spaces in between.

The file is just a list of names,address,phone,etc.

My boss and I decided to load it into the temp table and figure out how
to seperate the First, Last, and Middle initial into sepearate fields
and then move it into the appropriate table using an Informer but we're
not experienced with String parsing.

Anyone got any tips? I can't imagine this is a new problem, but we've
never dealt with it. Thanks much.

David Bannister Jr.
bannisd@gmail.com