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!

REGEXP_REPLACE with multiple chr() replacements ...

raudabatJul 10 2009 — edited Jul 10 2009

All,

I am trying to use the regexp_replace function to force the replacement of a group of special characters in a string. Is it possible in the function to have a mapping like replacing the following:
chr(150) with '-'
chr(132) with '"'
chr(146) with ''''

I know I can wrap a replace function to take of all the conditions but I was wondering if I could use a single regexp_replace function to do the same thing. Also, I has to go across a string containing cr, lf, .... ie multi-line.

Thanks In Advance,
Tom

This post has been answered by Karthick2003 on Jul 10 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2009

Added on Jul 10 2009

#sql

13 comments

2,895 views