Re: How to find non printable characters in a column using regexp
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: dd.yakkali@xxxxxxxxx
- Date: Sat, 14 Apr 2007 16:00:34 +0200
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@xxxxxxxxx> 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@xxxxxxxxxxxx
http://www.trivadis.com
=========================
Other related posts:
