Using evaluate for regexp_replace in OBIEE

Question

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 !

Rohit Trehan · Answer

It was helpful, but the accurate answer is:

EVALUATE('regexp_replace(%1,%2,%3)' AS CHAR,<OBIEE Column Name>,'[[:punct:][:space:]]+',' ')

ArijitC · Answer

EVALUATE('regexp_replace(%1,%2,%3)' AS CHAR,"Cost Center Attribute"."OWNER",'[[:punct:]]','')