Regexp NOT
2921435Nov 18 2008 — edited Jan 27 2011 Hello,
I know that regexp_replace('abc1234abc','[^[:digit:]]',null) will give me a string replacing anything that is NOT a number wiyth NULL
select regexp_replace('abc1234abc56def','[^[:digit:]]',null) from dual ---> 123456
Now, if I change the question slightly to "replace eveything that is ** not ** a digit followed by an alpha with null how cna I do that
i.e, I want the answer to be
select regexp_replace('abc1234abc56def','[^[:digit:][:alpha:]]',null) from dual ---> I.E i WANT "4A" AND "6D" TO BE INTACT
HOW ??
THANKS IN ADVANCE