Using Trim function in Message Template
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:
0