Parsing a charecter string (urgent)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Parsing a charecter string (urgent)

  1. #1
    Join Date
    Apr 2001
    Posts
    13

    Unhappy

    I have an address field in a table. The data looks something like this:

    1246 W 187th PL, Gardena, CA

    I need to take this data, break it up into 5 seperate fields:

    street adress, city, state, zip & extended zip.

    The data in the existing field is seperated by commas. None of the data is mandatory, so sometimes it's there and sometimes it's not. Can somebody help me parse this thing.
    I'm using C, Pro*C & PL/SQL. Any help would be appreciated.

    Thanx,
    Khurram.

  2. #2
    Join Date
    May 2000
    Posts
    58

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width