As you develop and test your process database, you may find it necessary to locate specific spreadsheet values. For example, you may want to locate and adjust the scan times of your primary blocks.
With Database Manager, you can search in any spreadsheet column for text by selecting the column head of the column you want to search in. You must also enter a search string. The string is the text you want to locate in the selected column. You can enter up to 29 alphanumeric characters for the search string.
Once you enter the text you want to locate, Database Manager locates the first occurrence of the string in the selected column. To locate subsequent occurrences, you can repeat this process.
Find Options
You can toggle the case sensitivity of a search using the Match Case option. When this option is enabled, Database Manager searches for the exact text and case you enter. The search string is not case sensitive when you disable the option. For example, selecting the Tag Name column and entering the search string:
AI
is the same as entering any of the following search strings:
- ai
- Ai
- aI
You can also find whole or partial words with the Match Whole Word Only option. Database Manager treats the search string as a whole word when you enable the option. By disabling the option, you can find the specified string inside other words. For example, if you search for the string "line" with the Match Whole Word Only option disabled, Database Manager matches the following descriptions with the search string:
- Alarms for Line 1
- Alkaline Pump
- Linear accelerator for proton chamber
