Hi All,
I have a scenario where the different rows has different delimiters ( space,colon,comma,semicolon). I can do it individually but looking for any possibility of giving all the delimiters at one
WITH TST(COL1) AS
(
SELECT 'ABC,123,XYZ' FROM DUAL
UNION
SELECT 'COLON1:COLON2:COLON3' FROM DUAL
UNION
SELECT 'SEMI1;SEMI2;SEMI3' FROM DUAL
)
SELECT REGEXP_SUBSTR(COL1,'[^,]+',1,LEVEL) FROM TST CONNECT BY LEVEL<=LENGTH(REGEXP_REPLACE(COL1,'[^,]+'))+1
Here I can separate only comma delimiter one's. How can i give the colon and semicolon delimiters?
Any pointers on this?