Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |