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 !