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