substitute_case_insensitive

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”

Related links

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
17092780895716899330
true
Search Help Center
true
true
true
true
true
5055977
false
false