Re: Removal or ACSII Code

Hi,

You can use translate function to remove special characters:

SVRMGR> select 'a'||chr(10)||'b' from dual; 'A'
---
a
b
1 row selected.
SVRMGR> select translate('a'||chr(10)||'b',chr(10),' ') from dual; TRA
---
a b
1 row selected.

Andrew Protasov

> Have a problem with users copy from Window apps and pasting into a
> "note" field - VARCHAR2(2000). The problem is that ASCII codes such as
> line feeds, tabs, etc are also copied and stored. When spooling to a
> delimited text file or exporting data these ASCII codes (CODES 1-31
> primarily) really can screw things up.
>
> Is there an ORA Utility or Update/Insert Trigger that I'm not aware of
> that I can use? If not any suggestions or sample code.
>
> Thanks
>
> Mike Gruntz
> mgruntz_at_ix.netcom.com
>
>
>
Received on Fri Dec 18 1998 - 03:17:18 CST