2 Replies Latest reply on Feb 22, 2018 9:00 PM by Rohit Trehan

    Using evaluate for regexp_replace in OBIEE

    Rohit Trehan

      Hi OBIEE folks,

       

      My goal is to use evaluate to incorporate regexp_replace to clean up a name column in the report.

       

      Below is my expression.

       

      select

       

      regexp_replace('John, Doe','[[:punct:]]',' ')  col_name

       

      dual;

       

      Can one you evangelists precisely suggest the evaluate syntax I can use ? I'd really appreciate the help,

       

      Also please suggest any parameters that I need to change in order to use the EVALUATE.

       

      I know there is a lot of stuff online however I would like to hear from someone who has actually implemented this himself/herself.

      Thanks a lot !