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

On Aug 7, 4:27 pm, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> 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.
>
> 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
> d...@nospam.peasland.nethttp://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 fromhttp://www.teranews.com

Brian,

I did dump
select dump(col_name) from my_table where ... Typ=1 Len=8: 0,0,0,0,0,0,0,0

I want to make them into
Typ=96 Len=8: 32,32,32,32,32,32

Which is space.

How do I do that?

I try to use translate, but I do not know how to de-dump? Those letter are not printed. I need something like UPDATE MYtable set
col1=de-dump(Typ=96 Len=8:32,32,32,32,32) where dump(col1)='Typ=1 Len=8: 0,0,0,0,0,0,0,0' Received on Wed Aug 08 2007 - 11:13:12 CDT