Skip to Main Content
Forums

SQL Developer

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 Charatcter � � from a String

Prakash GautamFeb 20 2017 — edited Feb 20 2017

Hello Team

I am not able to remove the special character having ascII value 63 using Oracle SQL logic.

I have tried with REGEXP_REPLACE, TRANSLATE as well  but could not able to remove the special character.

Ex: Intel � Xeon� 2.0GHz is a string  and i have lot of such string.   In all my strings the position  of special character � is not fixed and can be anywhere in the string.

I also found one expression, but it is removing all the special character including . value as well , which i wanted to keep.

UPPER(REGEXP_REPLACE( attribute3 ,'[^[:alnum:]'' '']', NULL))

Need help.

Thanks

Prakash
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2017
Added on Feb 20 2017
#sql-developer
4 comments
5,226 views