Returns a number of characters from the end of a specified string.
Sample usage
RIGHT_TEXT(Campaign, 4)
Syntax
RIGHT_TEXT(X, length)
Parameters
X- a field or expression of any type.length- The number of characters to include in the substring.lengthcan be a field, expression, or literal value.
Examples
| Example formula | Input | Output |
|---|---|---|
RIGHT_TEXT(Campaign, 4) |
Summer Sale | Sale |
RIGHT_TEXT(Campaign, 5) |
Summer Discount | count |