RIGHT_TEXT

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.

Notes

  • length parameter must be a literal value.

Examples

Example formula Input Output
RIGHT_TEXT(Campaign, 4) Summer Sale Sale
RIGHT_TEXT(Campaign, 5) Summer Discount count

Related resources

Was this helpful?
How can we improve it?