Searching

Search is done using an exact match. Use wildcards and operators below to customize them.

John All values that match exactly the word "John"

Wildcards

* Match any number of characters

John* All values that start with "John"

*Williams All values that end with "Williams"

*Smith* All values that contain "Smith"

. Match a single character

J.B Matches "JOB", "JEB", "JAB".

41. Main Matches "411 Main", "412 Main", "41A Main"

Operators

! Perform the opposite of a search

!John All values that aren't "John"

!*Main* All values that don't contain "Main"

& Perform multiple searches with an AND operation

!John&!Bill All values not "John" and not "Bill"

| Perform multiple searches with an OR operation

1|2|3 All values that are "1", "2", or "3"

( ) Use parentheses to group searches and change precedence

!(2|3) & !(6|7) Values not ("2" or "3") and not ("6" or "7")