Download Expert Tools - User's Guide
Transcript
AlarmInsight - Expert Tools Basic Operations Figure 3-14 Find Record Search field Specifies the field to search. Find what Enter your search criteria. If wildcards are to be used, the "Wildcard match" search type must be enabled. Match case Only locate records where the case matches. Keep selections If checked, each record found during the search is marked. At the end of the search, all marked records can then be copied to the clipboard or saved to a file. Search type Substring Find the search string anywhere in the field. Whole word Only find fields where a stand-alone word matches the search string. Starts with Only find fields that start with the search string. Wildcard match Use this type if wildcards are to be used in the search. Multiple character wildcard is '%' and single character wildcard is '?'. Wildcards can be combined like “Com%s?”, which will find “Compose”, “Compass”, but not “Composition”. Note that although the Find dialog stays on top, when you switch between the different tables, the Find dialog remembers the settings specified for each table. This means that the search settings do not have to be re-entered, when switching between the opened tables. The Find settings are only remembered as long as the table is open. 3.8 SQL Sort With the sort function, it is possible to sort the records in the table The Sort Table dialog can be opened by selecting the menu item Table | Sort... 3BEL303466R0101 Page 21 of 64