Exclude results from text search

Paul · November 17, 2011 10:35AM

What's the best way to exlude a word or text string from the results when using a text search filter? For example, how can I search for all rows of data that don't include the word 'vehicle' in a specific field that has a text search filter?

steve · November 17, 2011 11:16AM

Several ways:
Change a view's data subset to "filtered out"
Create a saved query of your filter state, then use the "saved queries" device to exclude that data
Select the data using selection within the views then click "Move"

steve · November 17, 2011 11:17AM

Or use regular expressions

November 23, 2011 5:38AM

For those who are unfamiliar with (or have only limited experience with) regular expressions, I strongly recommend "G Skinner's" online regex test tool at gskinner.com/RegExr/.

If you combine this with the official Regular Expresion Tutorial then you should be able to pick up the basics, and develop pretty quickly, in this *supremely useful* text-processing technique in Omniscope.

Welcome!

Categories

Ideas Parade

Tagged