Notification

This Help Center is moving to Cloud. Learn more about the migration.

ENDS_WITH

Returns true if the field or expression ends with the specified text, otherwise returns false.

Sample usage

ENDS_WITH(Campaign, "Sale")

Syntax

ENDS_WITH(X, text)

Parameters

  • X - a field or expression of any type.
  • text - the text to find within X. text can be a field, expression, or literal value. text is case-sensitive.

Examples

Example formula Input Output
ENDS_WITH(Campaign, "Sale") Summer Sale true
ENDS_WITH(Campaign, "Summer") Summer Sale false

Related resources

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

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