Find rows (advanced)

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:

  1. In an open table or worksheet, click Rows > Find Row (Advanced)...

    The Find Row dialog is presented.

  2. (required) In the Expression text box, enter a selection expression, which will be used to find a particular row.
    The selection expression may refer to one or more columns and may include standard arithmetic, relational, and logical operators as well as any of 1010data's functions.
    Note: When referring to a column in an expression, use the column name as opposed to the column heading. A list of all the column names for the table appears at the bottom of the Find Row dialog.

    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).

  3. (optional) Select Treat special values as NA? if you want special values treated as N/A in calculations.

    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).

    Note: There is a performance degradation associated with selecting this option, so it is best to not select it unless special values are, in fact, present.

    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.

  4. Click Find Next (or Find Previous) to find the next (or previous) occurrence of the row for which the selection expression evaluates to true.

    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.