Returns the first length characters in string counting from the end of the string. Counting starts from 1 (not 0).
Always counts in the natural direction of the advertiser’s locale. For example, if the advertiser’s language is English, this function counts from right to left.
This function can be used only in inventory templates in manual campaigns. Templates in upgraded inventory management use a different set of functions.
Syntax
RIGHT(string, length)
Specify the function name in upper case: RIGHT
Parameters
- string: An inventory attribute such as
BRAND
, or a static string surrounded by quotes such as "Shoes".
Specify standard attributes in upper case; use the Search Ads 360 UI for guidance on specifying custom attributes. - length can be any of the following:
- 0 (zero).
- A positive integer, such as 5.
- An expression or inventory function that returns a positive number.
Examples
-
RIGHT(BRAND, 6)
returns the last 6 characters of the brand name as retrieved from the inventory feed. -
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.