You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Using Trim function in Message Template

    edited Feb 25, 2021 3:37PM in Taleo Enterprise 7 comments

    Summary

    What is the correct syntax to use TRIM LEADING function in a message template?

    Content

    I'm trying to use the "TRIM LEADING" function in a message template for the following field Requisition.LocationStructure

    I'm trying to modify the field output as shown below...

    • Current – United States>California>San Francisco>San Francisco
    • Preferred – San Francisco

    I tried various combinations of the syntax below but it's not working.  The message template treats it like a text instead of a function.  What's missing from the syntax?

    TRIM(LEADING '>' FROM "Requisition.LocationStructure")

     

    Code Snippet

    TRIM(LEADING '>' FROM "Requisition.LocationStructure")
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!