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”