My requirement is to split string into words, including terminators (space,comma,semicolon,new line) etc
Words and Terminatorsalso should also come in output ?
How can I achieve that?
Query
select regexp_substr('testto ,mm\;' || '
string into words',
'\w+',1,level) from dual
connect by level <= regexp_count('testto,mm\;' || '
string into words
','\w+')
Desired Output
1 testto
2
3 ,
4 mm
5 ;
6 string
7
8 into
9
10 words
Currently it is skipping the terminators.
Can somebody help?
Thanks
Sree