Notification

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

REPLACE

Returns a copy of the original text with all occurrences of the search text substituted by the replacement text.

Sample usage

REPLACE(Campaign, "Summer", "Spring")

Syntax

REPLACE(X, Y, Z)

Parameters

  • X - a field or expression of any type.
  • Y - a field or expression of any type.
  • Z - a field or expression of any type.

Examples

Example formula Input Output
REPLACE(Campaign,"Summer","Spring") Summer Sale Spring Sale
REPLACE(Campaign,"Sale","Discount") Summer Sale Summer Discount

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