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”