Filter table using REGEXMATCH

Your marketing director wants a list of only the competitor campaigns on their desk in an hour. Though this is last notice, you know that you can combine your knowlege of regular expressions and the FILTER() function to get the refined list to your marketing director in the next hour.

In this exercise, you will be combining the functions FILTER() and REGEXMATCH() to generate a list of only the competitors campaigns. This exercise will help develop your understanding of how useful regular expressions are, as they can take care of minor mistakes in the spelling or structure of the campaign names - if the regex is set up properly, of course.