Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Formating a text field column values in Obiee
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
Answers
-
Hi,
REPLACE("Your table"."Your column", ',', ' ')
You must edit the column formula and use the REPLACE function to replace , and add a space instead.
0 -
Ever opened the formula editor? It's all explained in each function.
REPLACE('LNAME,FNAME', ',', ' ')
0 -
at least we agree
0 -
Thank you! Awesome, that worked and also very quick response.
0 -
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.
0 -
definitely
0
