Formating a text field column values in Obiee

Question

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] · Answer

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!