Operators for searching one/several texts in the field filter (Boolean)

From time to time you need to search for several texts in a table column at the same time or you want to exclude certain texts from the search. To do this, you can use various operators that are inserted in the "Filter" field of the column. Upper and lower case is generally ignored.

 

like => must be placed before each condition
or => outputs what matches one of the conditions
and => outputs what matches all conditions
not => inverts the respective condition
( ) => parenthesis // important for ordering the conditions (order of resolution, see 5. & following)

A few usage examples follow.

Table:

 

1. like "grün"
    all records, whose text contains "grün"
    => "Grünkohl", "Grünspan", "Immergrüne Eibe"

2. like "span" or like "buch"
    all records whose text contains "span" or "buch".
    => "Buche", "Buchweizen", "Grünspan", "Spanisches Moss"

3. not like "kohl"
    all records whose text does not contain "kohl"
    => everything except "Blumenkohl", "Grünkohl"

4. like "weizen" and not like "gmo"
    all records whose text contains "weizen" but not "gmo"
    => "Buchweizen", "Weizen".

5. (like "distel" or like "weizen") and not like "gmo"
    all records whose text contains "distel" or "weizen" but not "gmo"
    => "Buchweizen", "Riesendistel", "Weizen"

6. (like "distel" or like "weizen") and (like "riesen" or like "buch")
    all records whose text contains "thistle" or "wheat" but also "riesen" or "buch"
    => "Buchweizen", "Riesendistel"

7. (like "span" and like "moss") or (like "weizen" and like "gmo")
    all records whose text contains "span" and "moss", or "weizen" and "gmo".
    => "Spanisches Moss", "Weizen (GMO)"

With a little experimentation you can build virtually all possible combinations of search filters, see the table as .csv in the attachment.

Have fun!