Formating a text field column values in Obiee

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,

[Deleted User]

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!