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
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")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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