String Parsing Guidance

[psycoperl]

Hi All I was wondering if all you nice Access Gurus could provide me with some guidance.

I am used to working with comma deliminated text files and parsing them into a table. However I am now getting Fixed width datafiles and the Person's name for each record is no longer comma delminated (Seperating Last, First, Middle) It now comes in chunk of text that is 25 characters long.

I have created an import specification that breaks up the fixed width into the appropriate columns into a tempTable so that I can further process and add it into my database.

What I need to do is split the name into First Middle(if present) and last.

I would get data that is like


Lunqvist Henrik
St Croix Mark
Zuccerello Assen Matts
De Santos Rose Maria
Groh Michael R


If there is only one space, I would like to just split it Last, First
However if there is more than one, I would need to have it prompt the user to split it into the two or three parts.

Don't know the best way to do this. Any guidance you can provide would be great!