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 an expression of any type.length- The number of characters to include in the substring.lengthcan be a field, an expression, or a literal value.
Examples
| Example formula | Input | Output |
|---|---|---|
RIGHT_TEXT(Campaign, 4) | Summer Sale | Sale |
RIGHT_TEXT(Campaign, 5) | Summer Discount | count |
Related resources
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-02-19 UTC.