Re: REGEXP_REPLACE doesn't give the desired output

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 20 Jun 2006 09:56:40 -0700
Message-ID: <1150822600.604831.284120@g10g2000cwb.googlegroups.com>

Jure wrote:
> Hi Jim,
>
> as i said I tried to hardcode the timestamp, thus the input to
> REGEXP_REPLACE was a character type.
>
> Another example. Running:
>
> SELECT REGEXP_REPLACE('1234 A B C', '\D', '')
> FROM dual
>
> gives the result:
>
> '1234 A B C'

Perl-influenced operators were introduced in 10.2, so obviously they don't work in 10.1. You need to use equivalent regular expression in 10.1, for example '[^[:digit:]]' or '[^[0-9]]'.

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Tue Jun 20 2006 - 11:56:40 CDT