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”