Exception in Filter

[jboschee]

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 solution]

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

[jboschee]

Awesome!  Thanks David