How to parse out name from Excel spreadsheet
 

I have a question of how to parse a name from an excel spreadsheet. You see we have multiple spreadsheets and we need to seperate out each piece of the name to import into an Oracle database. Our fields in the database are the PREFIX, FNAME, MNAME, LNAME, SUFFIX. Here are some examples of what type of data we are working with: Lt. Jerry Goodman
Paul F. Clark, II

Any help with this will be really appreciated!!

Re: How to parse out name from Excel spreadsheet
 

Can anybody help me?

Re: How to parse out name from Excel spreadsheet
 

Yup, If you please look the topic of forum before posting it. You posted it in Introduction topic.

Re: How to parse out name from Excel spreadsheet
 

Moved

Re: How to parse out name from Excel spreadsheet
 

Do you mean that each piece of name is separated with space?
If yes than that would be simple.

Re: How to parse out name from Excel spreadsheet
 

I am not sure I understand the problem, other than that you want to do "something" with a spreadsheet. (I apologize if I am not understanding that correctly.) One of these scripts may help - biterscripting.com/samples_data.html .

Randi