left

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.

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
6015101319802213978
true
Search Help Center
true
true
true
true
true
5055977
false
false