Search Options Reference
When using search in the Parameters dialog, you have the following options how to define the search criteria:
Search For | How to Search | Example |
Single keyword | Type the desired word. | d12 |
Multiple keywords | Type multiple keywords separated by spaces. | d12 d13 |
An exact match of a phrase | Put the phrase in quotes. | "distance" |
Search in a specific column only Note: You can enter incomplete column names. The search results are shown for the first column whose name matches the entered string | Enter a column name before a keyword followed by a colon (without space). Note: If the column name has multiple words, use quotation marks for the column name. | Equation:deg "Model Value": 120 |
Include special symbols in a query | To include quotation marks, brackets or keyword modifiers in a query, put the query in single or double quotes. | 'Mate:1' "d22 + d37 |
Options and Modifiers
You can enable one of the following operators used to compare words in records with keywords in a query:
Operator | Description |
Contains | Searches for words that contain keywords. |
StartsWith | Searches for words that start with keywords. |
Like | Searches for words that match a pattern. Use the % wildcard to replace one or multiple characters. |
Equals | Searches for words that equal keywords in the query. |
You can override the specified comparison operator for a particular keyword using modifiers.
Modifier | Operator |
* | Contains use this modifier to search for words that start with keywords, but a particular keyword doesn't have to be in the beginning. |
^ | StartsWithuse this modifier to search for words that contain keywords, but a particular keyword doesn't have to be in the beginning. |
~ | Like. |
= | Equals. |
You can override the specified mode for a particular keyword using the following modifiers:
Modifier | What It Does |
? | Optional keyword. Use this modifier if results should contain all keywords, but a particular keyword is optional. |
+ | Mandatory keyword. Use this modifier if results should contain any of the keywords, but a particular keyword is mandatory. |
- | Exclude keyword. |