0 Replies Latest reply on Dec 5, 2019 5:24 PM by Arsha

    remove the last 2 special characters from a string in oracle sql

    Arsha

      REgexp_replace should replace 2 special characters from the end of the string .

      The special character can be single quote('),ampersand,forward slash,dash . tried the below but it removes all the special characters.

       

      select regexp_replace(trim('Clifton/RosalieBolner''49-S.R.'),'[-/&'']','') from dual;

       

      Any suggestion with the pattern matching.