Categories
- All Categories
- 142 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Formating a text field column values in Obiee

User_HQ9TE
Rank 3 - Community Apprentice
Hi There,
Hoping you are are doing good and get a quick min to answer my question below.
I have a campaign name in this format 'name-dd/mm/yyyy' . I would like to remove '-dd/mm/yyyy' and have the data in this format 'name'
How can I achieve this text field format in OBIEE?
Thanks very much,
0
Answers
-
LEFT('SportsCampaign-20/05/2024', LOCATE('-','SportsCampaign-20/05/2024')-1)
It's basically just an instruction of giving you everything to the left if the '-'. Minus one because otherwise you get "SportsCampaign-" as a result.
Cheers!
1