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: Wed, 08 Aug 2007 09:48:15 -0700
Message-ID: <1186591695.241879.303170@w3g2000hsg.googlegroups.com>


On Aug 8, 1:13 pm, emdproduct..._at_hotmail.com wrote:
> 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'- Hide quoted text -
>
> - Show quoted text -

update MYtable
set col1= translate(col1, chr(0),chr(32)); Received on Wed Aug 08 2007 - 11:48:15 CDT

Original text of this message

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