Returns the first length characters in string counting from the beginning 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 left to right.
Syntax
left(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
left("Hello World!", 5)
returns Hello.left("Hello World!", 0)
returns "" (empty string).left("Hello World!", -1)
is an error. Negative numbers are not valid.left(right("Hello World!", 6), 5)
returns World.