Notification

This article is about Looker Studio. For Looker documentation, visit https://cloud.google.com/looker/docs/intro.

LEFT_TEXT

Returns a number of characters from the beginning of a specified string.

Sample usage

LEFT_TEXT(Campaign, 6)

Syntax

LEFT_TEXT(X, length)

Parameters

  • X - a field or expression of any type.
  • length - The number of characters to include in the substring. length can be a field, expression, or literal value.

Examples

Example formula Input Output
LEFT_TEXT(Campaign, 6) Summer Sale Summer
LEFT_TEXT(Campaign, 3) Summer Sale Sum

Related resources

Was this helpful?

How can we improve it?
true
Get Looker Studio Pro

Upgrade now to get all the features of Looker Studio that you already know, plus enhanced enterprise capabilities and technical support

Search
Clear search
Close search
Google apps
Main menu
9553042081477994004
true
Search Help Center
true
true
true
true
true
102097