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).


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

* 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.




Stefan P Knecht
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


Other related posts: