Filter Type | Description and Examples |
text | Any text entered in the filter will match text found within the column.
attack (finds "Base Attack Bonus", "Ranged Attack Bonus", "Bleeding Attack", etc);
|
/\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig )
/b[aeiou]s/i (finds "Base Attack Bonus", "Bestow Curse", etc);
|
< <= >= > | 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. Filters the column with content that does not match the query. Include an equal (= ), single (' ) or double quote (" ) to exactly not match a filter.
!ge (hide rows with "General" in that column, but shows "Fighter", "Cleric", "Rogue"); !"Abjurer" (find content that does not exactly match "Abjurer")
|
" or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
Aid" or Aid= (exactly match "Aid")
|
&& or AND | Logical "and". Filter the column for content that matches text from either side of the operator.
channel && harm (matches a cell that contains both "channel" and "harm");
|
- 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)
|
? | Wildcard for a single, non-space character.
a?i (finds "Acid Arrow" and "Agile Feet", but not "Alchemist")
|
* | Wildcard for zero or more non-space characters.
a*i (matches "Acid Arrow", "Agile Feet", and "Alchemist")
|
| or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar.
rogue|fighter (matches either "Rogue Maneuver" or "Fighter Maneuver")
|
~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query.
~baa (matches "Balestra and "Bleeding Attack"), or ~paizo (matches "Axe Specialization")
|