Regex Help - Aggregating Campaign Data
Hey studio community. I'm new to regex and I'm trying to aggregate multiple campaigns into one for reporting purposes.
For example I'd like all the data for any campaign that contains the word "Search" to combine into an aggregate campaign named "Search". Same goes for all the data for any campaign containing "GDN". When i tried using the vertical bar (OR function) and exact campaign names I ran out of characters, and I was unsuccessful at my attempt to use wildcards.
The long version (shortened here) that I tried but ran out characters in the process looked like this...
WHEN Campaign, "(2017 - Search - Neighborhoods|2017 - Search - Branded Campaign)" THEN "Search"
WHEN Campaign, "(2017 - GDN - Food Category / Shortcut Campaign|2017 - GDN - Lead Acquisition - Food Category / Shortcut Campaign)" THEN "GDN" ELSE "Other" END
Here are the campaigns I'm trying to aggregate. Any help would be greatly appreciated!!!