Re: How to find non printable characters in a column using regexp

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Sat, 14 Apr 2007 16:00:34 +0200
Message-ID: <486b2b610704140700h59ad7996u3d0a9f1b1aef38b6@mail.gmail.com>

If you are on 10.2 (you didn't say) - take a look at the perl extensions to oracle's regular expressions. Namely the \W operator (non-word).

Stefan

On 4/13/07, dd yakkali <dd.yakkali_at_gmail.com> wrote:
>
> I am trying to find the records where there are non printable characters,
> i am not having success with it
>
>
> select
> * from njcrc .tblprogram where REGEXP_INSTR(description,'[[:cntrl:]]') >0;
>
>
>
> Above sql pulls records where there are no "non printable" characters.
>
> Can any point me to an alternate way achieving this or let me know what am
> i doing wrong.
>
>
>
> Thanks
>
> Deen
>

-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

=========================

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

Received on Sat Apr 14 2007 - 09:00:34 CDT