Skip to main content

Using Advanced Expressions: Left\/Right

Distributor reference for the LEFT and RIGHT advanced expressions in Fusion reports: syntax, arguments and examples for returning the leftmost or rightmost characters of text. Needs FusionEdit permission, v23.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 23.01

Pre-Conditions

  • Required Permission - FusionEdit
    ​
    ​

  • Recommended Fusion I/II Certification

Steps

Returns a leftmost or rightmost substring of its input. Can specify the number of characters that returns.
​
​


​Syntax
​
​
LEFT(Value1,#)
​
or
​
RIGHT(Value1,#)


​
​Arguments
​
​
Value 1:

The text string which will be used.
​
​

#:

The number of text characters that will be pulled from the left/right side of the text string.
​
​


Example
​
​
LEFT('Encompass',3) = Enc
RIGHT('Encompass',4) = pass

PDF

Did this answer your question?