1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

How to parse out name from Excel spreadsheet

Discussion in 'Windows' started by kdr1178, Sep 3, 2009.

  1. kdr1178

    kdr1178 New Member

    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!!
     
  2. kdr1178

    kdr1178 New Member

    Can anybody help me?
     
  3. naimish

    naimish New Member

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

    shabbir Administrator Staff Member

    Moved
     
  5. nimesh

    nimesh New Member

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

    RandiR New Member

    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
     

Share This Page