Regular expressions: splitting with REGEXP_SUBSTR and "null"
Date: Thu, 28 Feb 2008 08:02:53 -0800 (PST)
I have a problem, I found on internet a way to split strings separated by pipe | (for example) with regexp, something like that:
SELECT REGEXP_SUBSTR('One|Two|Three|Four','[^|]+', 1, 3) FROM dual;
which gives the result:
the problem comes when I have one of the words separated by the pipe is actually a Null, so the string becomes 'One|Two||Four|'
SELECT REGEXP_SUBSTR('One|Two||Four','[^|]+', 1, 3) FROM dual;
I needed a Null (or empty string).
How is this possible?
Thank you in advance! Received on Thu Feb 28 2008 - 10:02:53 CST