4 Replies Latest reply on Feb 20, 2017 2:45 PM by 3231041

    Remove Special Charatcter  � �  from a String


      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.