text |
Any text entered in the filter will match text found within the column |
abc (finds "abc", "abcd", "abcde", etc);
Aaron (finds "Aaron" and "Philip Aaron Wong")
|
/\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")
|
< <= >= > |
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) |
! 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.
|
!fe (hide rows with "female" in that column, but shows rows with "male");
!a (find text that doesn't contain an "a")
|
" 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")
|
&& or
AND
|
Logical "and". Filter the column for content that matches text from either side of the operator. |
box && bat (matches a column cell that contains both "box" and "bat");
Br && c (Find text that contains both "br" and "c")
|
- or
to
|
Find a range of values. Make sure there is a space before and after the dash (or the word "to") (4). |
10 - 30 or
10 to 30 (match values between 10 and 30)
|
? |
Wildcard for a single, non-space character. |
J?n (finds "Jan" and "Jun", but not "Joan")
|
* |
Wildcard for zero or more non-space characters. |
B*k (matches "Black" and "Book")
|
| or
OR
|
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar (3). |
box|bat (matches a column cell with either "box" or "bat")
|
~ |
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query (v2.13.3) |
~bee (matches "Bruce Lee" and "Brenda Dexter")
|