'What is the regex value for showing all the results that do not contain certain text in Google Data Studio?

I want to return all of the values that do not contain a specific set of characters.

I'm using the Advanced Filter option in Google Data Studio, and it has a Contains option, but not have a 'Does not contain' function. It does have Regex however, and I'm trying to create a regex that shows all of the values that do not contain a specific set of character.

The following regex returns all of the values that contains the word cat:

.cat.

But I want it to display all of the values that do not contain cat.

What do I need to do to it to get it to work?

Thanks!

example of Google Data Studio Advanced Filter

regexfilter


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions