Re: Regular Expression confusion

From: Jared Still <jkstill@xxxxxxxxx>
To: wbfergus@xxxxxxxx
Date: Thu, 21 Apr 2005 00:51:53 +0100

Hi Bill,
Have you tried using dump() on the row?

It is possible that the '-' is not quite what you think it is.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


On 4/20/05, William B Ferguson <wbfergus@xxxxxxxx> wrote:
> 
> 
> SQL> set escape off
> SQL> select UPPER(regexp_replace(name,'[''''|"|;| |-|,|.]')) test_data
> 2 from names
> 3 where upper(regexp_replace(name,'[[:punct:][:space:]]'))
> 4 like ('%JGO%');
> 
> TEST_DATA
> ----------------------------------------------------------------------
> A-JGOLDMININGCO
>

--
http://www.freelists.org/webpage/oracle-l

References:

Regular Expression confusion
From: William B Ferguson

Re: Regular Expression confusion

Other related posts: