Exception in Filter

Question

Hi everyone,

I'm trying to make an exception in my filter.

Team Name    DOES NOT CONTAIN    Chicago

but I want to keep in Chicago Bears

Not sure if this is possible or if I'm using the wrong approach.

Thanks for the help in advance!

David-Carnes · Accepted Answer

OK, Text tool  has

da bears    *   
1 Chicago
2 Chicagoland
3 Chicago Tribune
4 Chicago Bears
5 Taste of Chicago
6 Jacksonville Jaguars

Filter has  a Custom Filter:

[da bears] = "Chicago Bears"
or !Contains([da bears], 'Chicago')

Output =

da bears
Chicago Bears
Jacksonville Jaguars

If you need something to pull out of sentences we'll need to look at regular expressions.

Best,

David