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

• About calculated fields
• Looker Studio function list