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

  • From: "Madhu Sreeram" <madhusreeram@xxxxxxxxx>
  • To: dd.yakkali@xxxxxxxxx
  • Date: Fri, 13 Apr 2007 13:12:33 -0500

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

how about this:
select regexp_replace(string,'[^[:cntrl:]]') from dual; --returns just
control characters.

-Madhu S

Other related posts: