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
-
Text Functions
Format:
Article,
1 min read