Find operators
You can use the following operators in Find mode. The only operator supported by quick find is double quotation marks (" ").
Operator | Description |
---|---|
= |
match whole word (or match empty) |
== |
match entire field |
! |
find duplicate values |
< |
less than |
<= |
less than or equal to |
> |
greater than |
>= |
greater than or equal to |
... |
range |
// |
today's date |
? |
invalid date or time |
@ |
any one character |
# |
any one digit |
* |
zero or more characters |
\ |
escape next character |
"" |
match phrase (from word start) |
*"" |
match phrase (from anywhere) |
~ |
relaxed search (Japanese only) |