Substitutes all instances of needle in haystack with replacement.
Syntax
substitute(haystack, needle, replacement)
Parameters
haystack
, needle
and replacement
can be any of the following:
- Static text, such as 'GDN'.
- A Search Ads 360 variable that is a string, such as
Keyword
,Campaign
and so on. - An expression or formula column that returns a string.
Examples
- If keyword contains 'summer shoes', substitute 'sandals' for 'shoes':
substitute(“summer shoes”, "shoes", "sandals") = “summer sandals”