Oracle Business Intelligence

Products Banner

Formating a text field column values in Obiee

Received Response
21
Views
1
Comments
User_HQ9TE
User_HQ9TE ✭✭✭

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,

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!