Formating a text field column values in Obiee

2765583

Hi There,

Hoping you are are doing good and get a quick min to answer my question below.

I have a supervisor full name in this format 'LNAME,FNAME' . I would like to remove comma between last name and first name and have the data in this format LNAME FNAME

How can I achieve this text field format in OBIEE?

Thanks very much,

KK

Gianni Ceresa

Hi,

REPLACE("Your table"."Your column", ',', ' ')

You must edit the column formula and use the REPLACE function to replace , and add a space instead.

[Deleted User]

Ever opened the formula editor? It's all explained in each function.

REPLACE('LNAME,FNAME', ',', ' ')

Gianni Ceresa

at least we agree

2765583

Thank you! Awesome, that worked and also very quick response.

Gianni Ceresa

So can you maybe close the thread? Other users with similar question will know they can find something interesting on here. For now it's still This question is Not Answered.

[Deleted User]

definitely