| 1 | | or OR
| Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar.
| <20 | >40 (matches a column cell with either "<20" or ">40")
|
| 2 | && or AND
| Logical "and". Filter the column for content that matches text from either side of the operator.
| >20 && >40 (matches a column cell that contains both ">20" and "<40")
|
| 3 | /\d/
| Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
| /b[aeiou]g/i (finds "bag", "beg", "BIG", "Bug", etc);>/r$/ (matches text that ends with an "r")
|
| 4 | < <= >= >
| Find alphabetical or numerical values less than or greater than or equal to the filtered query .
| <=10 (find values greater than or equal to 10)
|
| 5 | ! or !=
| Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
| !e (find text that doesn't contain an "e");!"ELISA" (find content that does not exactly match "ELISA")
|
| 6 | " or =
| To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
| abc" or abc= (exactly match "abc")
|
| 7 | - or to
| Find a range of values. Make sure there is a space before and after the dash (or the word "to").
| 10 - 30 or 10 to 30 (match values between 10 and 30)
|
| 8 | ?
| Wildcard for a single, non-space character.
| S?c (finds "Sec" and "Soc", but not "Seec")
|
| 8 | *
| Wildcard for zero or more non-space characters.
| B*k (matches "Black" and "Book")
|
| 9 | ~
| Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
| ~bee (matches "Bruce Lee" and "Brenda Dexter"), or ~piano (matches "Philip Aaron Wong")
|
| 10 | text
| Any text entered in the filter will match text found within the column
| abc (finds "abc", "abcd", "abcde", etc);SEC (finds "SEC" and "Analytical SEC")
|