SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove Junk Characters

734241Jan 7 2010 — edited Jan 7 2010

Hi,
I have a bunch of tables with columns (mainly varchar2 (4000)) which are populated with data from an external source, and have 'garbage' characters in them. I need to strip out the garbage, and leave only the standard (UK) keyboard character set (a-z, A-Z, 0-9, space, !,£ $ etc).
My database is 10g, on Solaris.
I have looked at REPLACE and TRANSLATE, but I can't see how I could apply them to this problem.

Any ideas how I can do this?

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 4 2010

Added on Jan 7 2010

9 comments

4,421 views