Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Formating a text field column values in Obiee

Received Response
21
Views
1
Comments
User_HQ9TE
User_HQ9TE Rank 4 - Community Specialist
edited August 2024 in Oracle Analytics Cloud and Server

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,

Tagged:

Answers

  • [Deleted User]
    [Deleted User] Mod

    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!