right

Returns the last length characters in string counting from the end of the string. Counting starts from 1 (not 0).

Always counts in the natural direction based on the selected locale. For example, if the language is English, this function counts from right to left.

Syntax

right(text, length)

Parameters

text can be any of the following:

  • Static text, such as "GDN".
  • A Search Ads 360 variable that is a String, such as Keyword, Campaign, and so on.
  • An expression or formula column that returns a String.

length can be any of the following:

  • A positive constant, such as 5.
  • A Search Ads 360 variable that is a positive number.
  • An expression or formula column that returns a positive number.

Examples

  • right("Hello World!", 6) returns World!
  • right("Hello World!", 0) returns "" (empty string).
  • right("Hello World!", -1) is an error. Negative numbers are not valid,
  • left(right("Hello World!", 6), 5) returns World.

Related links

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
14192123848867293938
true
Search Help Center
true
true
true
true
true
5055977
false
false