Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I find the un-printable letters?

Re: How do I find the un-printable letters?

From: Chris L. <diversos_at_uol.com.ar>
Date: Tue, 07 Aug 2007 12:45:15 -0700
Message-ID: <1186515915.933984.68200@b79g2000hse.googlegroups.com>


On 7 ago, 15:27, emdproduct..._at_hotmail.com wrote:
> Dear group,
>
> I loaded data from a file coming from other source, in sqlplus, some
> of the data appear as space, but they are NOT. And it will cause our
> application which uses xml to fail.
>
> How can I find those ghost bytes and convert them into space?
>
> Thanks for your help.

Find out all the nonprintable characters, build a string with them, and use the TRANSLATE function

update table_one
set bad_data_column= translate(bad_data_column, '', ' '); Received on Tue Aug 07 2007 - 14:45:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US