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,043
    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,375
    Likes Received:
    388
    Trophy Points:
    83
  5. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    769
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    http://techiethakkar.blogspot.com
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice