Parsing string from a single column to multiple columns (address data)
user586May 4 2006 — edited May 4 2006Hi,
Please reply,
I have TEMP_TBL which I am using as a staging area to clean up data before inserting it into EMPLOYEE table. One of my big issues is with the column ADDRESS which contains all address components. I need to parse out the address components into the following columns: STREET1, STREET2, CITY, STATE, ZIP. Most of the time, a comma is acting as a delimiter between the address components in ADDRESS column. Please help -- I have not been able to get this to work.