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

Related resources

• Calculated fields
• Looker Studio function list