Brian Peasland wrote:
> 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
You can also use Oracle's REGULAR EXPRESSIONS to find all non
alphanumeric characters. Take a look at REGEXP_REPLACE.
http://www.psoug.org/reference/regexp.html
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Aug 07 2007 - 16:09:38 CDT
