Notification

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

TRIM

Returns text with leading and trailing spaces removed.

Sample usage

TRIM(Campaign)

Syntax

TRIM(X)

Parameters

  • X - literal text, a field, or an expression containing at least one field.

Examples

Example formula Input Output
TRIM(Campaign)
"   Summer Sale "
"Summer Sale"
TRIM(Campaign)
"Summer @2019 Sale   "
"Summer @2019 Sale"

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
476262289357366347
true
Search Help Center
true
true
true
true
true
102097
false
false