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.