Removal or ACSII Code

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 Thu Dec 17 1998 - 17:56:45 CST