Looker Studio is now called Data Studio. Learn more about this change.

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

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2026年08月26日 UTC.