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