substitute_case_insensitive
will substitute all instances (case insensitive) of "needle
" in "haystack
" with the replacement text.
Syntax
substitute_case_insensitive("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_case_insensitive(“Summer Shoes”, "shoes", "sandals") = “Summer sandals”