Right Function

Description:
The last (rightmost) characters in a text.
Returns:
Text
Parameters:
Parameter
Data Type
Description
1
Text
The text.
2
Whole Number
The number of characters required.
Examples:
When using functions inside a field, remember the field brackets:
{Right(VariableName), 1}
Expression
Result
Right( "abc", 0 )
""
Right( "abc", 2 )
"bc"
Right( "abc", 5 )
"abc"
This is commonly used as a business rule on a span:
The name of the Buyer is {BuyerName}[
Right(BuyerName, 1) IsNot "."
.]

Related content