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.length
can 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 |