Back to Table of Contents
Search is another new function available in Vista 2.0 and allows any one parameter to be tested for a number of conditions.
Choose one parameter from the spreadsheet and press Search. There is no restriction on parameter type as the routine automatically determines the format of the data. The Search pop-up menu will appear.
In the simple case of a number, a cut-off value is typed into the Limit text field. One of the FORTRAN conditional operators needs to be selected. The default is .EQ.. If the parameter being tested is composed of characters then characters can also be entered into the Limit field.
In the case of a real value, the tolerance field is active. This allows for experimental error. For an integer value, this field is automatically greyed out. In the case of character string searches, the tolerance field is also disabled.
The Exact match button is only active for string searches. If for example you wished to search for the refcode ABCDEF, with the Exact match button disabled, the following refcodes could be matched (if they appear in the table file and are active) ABCDEF, ABCDEF10, ABCDEF21, etc. With the Exact match button activated, only the first of the above refcodes would have been matched.
Once the Search criteria have been specified, hit OK and the function will be performed (choosing CANCEL will return to the spreadsheet). All of the entries that are matched by the Search criteria will appear highlighted in the spreadsheet. The dialogue bar at the top of the spreadsheet window will also report the number of hits satisfied by this Search function for that particular dataset.
More meaningful names can be given to the parameters. Re-naming can only be applied to one parameter at a time.
Select one parameter in the spreadsheet and hit Re-name. The Re-name Parameter pop-up menu will appear allowing the user to type in a new parameter name.
The text keyed into the text field will be converted into upper case and the new name will be compared against the others to check for duplicates. An error pop-up will inform if the name is unsuitable. To remain consistent with Quest, the parameter names have a maximum length of 6 characters.
To export data, select the parameters of interest and press Export. The order of selection is mirrored in the output file column order. The Export Table File pop-up menu will appear.
The user can choose from the variety of column separators given in the scrolling list, with the default setting being to TAB delimited text. The export filename can be specified in this menu with the default being filename.exp. Parameter names can be added as Column Headings and a column of the Line Numbers can also be inserted. Any suppressed data in the spreadsheet will not be exported.
This feature may be particularly useful if there is a need to visually compare, line-by-line, two columns which are not adjacent in the spreadsheet.
If more than two parameters are selected in the spreadsheet an error message will be reported. This is also true if only one parameter is selected.
For consistency reasons the NFRAG and REFCOD fields are not permitted to be swapped with any other fields.
If one or more parameters are already selected when Select Par is pressed, the previous selection order is erased and a new order imposed which follows sequentially from 1 (NFRAG) to N.
NFRAG and REFCOD are protected against deletion.
Back to Table of Contents
Spreadsheet part 4 .