Hello
Good Day!
My requirement is to split the string into words.
So I need to identify newline charactor and semicolon (;) ,comma and space as terminator for input string.
Please note I'm currently incorporated blank and comma as seperator as shown below.
select regexp_substr('test
to
string into words', '([^,[:blank:]]+)', 1, 1) from dual;
How do i incorporate newline charactor and semicolon in Oracle Regular expression?
Please advise.
Thanks & Regards
Sree