8/22/18

How to extract comma separated values from a String or Column or Field in Oracle

Ex: Address >     123 Main St,New York , NY , 00123

SELECT  REGEXP_SUBSTR (Address, '[^,]+', 1, 1)    AS Street
,       REGEXP_SUBSTR (Address, '[^,]+', 1, 2)    AS City
,       REGEXP_SUBSTR (Address, '[^,]+', 1, 3)    AS State
,       REGEXP_SUBSTR (Address, '[^,]+', 1, 4)    AS Zip
FROM    table_x

0 comments:

Post a Comment