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 special characters and also make multiple space into single space

user7351276Oct 29 2011 — edited Oct 30 2011

Hi am trying to get rid of special characters and make the multiple space occurence into single.

But using the below code I get rid of the multiple space but special characters are not getting replaced.

SELECT trim(REGEXP_REPLACE(REPLACE(testword, '', ' '),'(^[[:blank:]])*( ){2,}|([\\*;%&$´`€])|([_.+-,-\-.])*(([[:blank:]]*)IMAGE?$|RANGE?$)', ' ')) as testword,
from tableA

Can anybody tell me what is the correct pattern I need to use here.

Any suggestions.?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 27 2011

Added on Oct 29 2011

3 comments

1,848 views