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

    Remove Special Charatcter  � �  from a String

    3231041

      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