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

Thread: Parsing a charecter string (urgent)

  1. #1
    Join Date
    Apr 2001


    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.


  2. #2
    Join Date
    May 2000

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