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.




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




      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 !