|Rows and Columns | Rows ||
You can find particular rows using a selection expression, a mathematical formula that evaluates to 1 (true) or 0 (false).
To find a particular row using a selection expression:
The Find Row dialog is presented.
For example, to find a row where the transaction ID (transid) is between 535 and 540, use the selection expression between(transid;535;540).
Generally, each operator and function in the selection expression deals with N/A values in a reasonable way, but see the description of each operator and function for details. For instance, price<100 is 0 (false) for any N/A values in the price column; to find rows where a column is (or is not) N/A, use a value of NA (e.g., price<>NA).
Although the majority of table columns do not have special values, some columns have special values that represent a kind of missing value. Special values are specified when the data is initially loaded into 1010data. To find out if a column has special values, show the column information for that column (or for all columns).
In a Price column, for instance, a value of 999 might indicate that the price was unavailable, while a value of 888 might mean that it was not applicable. In both cases, the values would be treated as N/A rather than used in calculations if this option was selected.
The next (or previous) row for which the selection expression evaluates to true becomes the current row, and its row number is displayed at the top of the Find Row dialog. If no rows match the search criteria, an error message indicating that no matches have been found is displayed.