1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to parse out name from Excel spreadsheet

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

  1. kdr1178

    kdr1178 New Member

    Joined:
    Sep 3, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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

    Joined:
    Sep 3, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Can anybody help me?
     
  3. naimish

    naimish New Member

    Joined:
    Jun 29, 2009
    Messages:
    1,046
    Likes Received:
    18
    Trophy Points:
    0
    Occupation:
    Software Engineer
    Location:
    On Earth
    Yup, If you please look the topic of forum before posting it. You posted it in Introduction topic.
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,292
    Likes Received:
    365
    Trophy Points:
    83
  5. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    Do you mean that each piece of name is separated with space?
    If yes than that would be simple.
     
  6. RandiR

    RandiR New Member

    Joined:
    Mar 1, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    0
    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