Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Windows (http://www.go4expert.com/forums/windows-forum/)
-   -   How to parse out name from Excel spreadsheet (http://www.go4expert.com/forums/parse-excel-spreadsheet-t19290/)

kdr1178 3Sep2009 20:31

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!!

kdr1178 4Sep2009 01:04

Re: How to parse out name from Excel spreadsheet
 
Can anybody help me?

naimish 4Sep2009 08:49

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.

shabbir 4Sep2009 09:46

Re: How to parse out name from Excel spreadsheet
 
Moved

nimesh 5Sep2009 20:22

Re: How to parse out name from Excel spreadsheet
 
Quote:

Originally Posted by kdr1178 (Post 56769)
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!!

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

RandiR 22Sep2009 22:48

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


All times are GMT +5.5. The time now is 15:58.