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

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

The DUMP function can show you the ASCII codes in your text data similar to the following:

SQL> select dump(table_name) from sde.layers

   2 where rownum < 4;

DUMP(TABLE_NAME)

Typ=1 Len=12: 65,68,77,78,95,49,95,80,76,89,71,78
Typ=1 Len=12: 65,68,77,78,95,50,95,80,76,89,71,78
Typ=1 Len=12: 65,68,77,78,95,51,95,80,76,89,71,78

When you know which ASCII characters are causing your problems, you can use TRANSLATE to remove them.

HTH,
Brian

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

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com