| 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")
|