next up previous contents index
Next: 10 Interacting with Other Up: 9 Shortcuts and Tools Previous: 9.4 Sort

9.5 Extract

   

Extract is a facility for managing internal databases. Internal databases consist of records stored as rows. Extract allows you to selectively retrieve a set of records based on a selection criteria.

To Extract a range of cells:

  1. Select Extract from the Tools menu. NExS displays the Extract dialog box as shown in Figure 9.3.

  2. Enter the following specifications:
    Source Range -
    Enter the range of records from which extract will be performed.
    Key -
    Specify the key column cell address on which you want to base the extract. This column represents ``#'' in a constraint expression specified in Filter.
    Destination -
    Enter the beginning cell address where the extracted records will be placed.
    Filter -
    Specify the string or value as it would appear formatted in the cell. To find a numeric value that meets a certain criteria, enter the Filter with a constraint expression. For example to extract values less than 20, specify the Filter as #<20.

    1. To extract a literal character string, type the string inside the Filter entry box as it would appear when formatted in the cell. Examples: Doe, John, or $1,000,000

    2. To extract numeric values that meet certain criteria, enter the target with a constraint expression. # is used to represent the current cell being examined. Select Numeric Search. For example:

      1. To find values less than 20, specify the target as #<20

      2. To find values greater than or equal to 50, specify the target as #>=50

      3. To find cells whose values are less than 600 and whose neighboring cells in the same column have values less than 500, specify the target as: #<600 && #{0,-1}<500 && #{0,1}<500

      4. To find the cell containing the date August 22, 1991, specify the target as: #==@DATE(91,8,22)

  3. Click on the check button labeled Numeric Comparison if you using a numeric find pattern.

  4. Click OK or Apply to begin.. NExS will extract the data and place it in the destination range. Apply leaves the Extract dialog displayed on the screen.

  5. Click Cancel to quit Extract.

   figure3150
Figure 9.3: Extract Dialog Box


Use the Undo Extract operation from the Edit menu to cancel the most recent extract operation. All cells are returned to their original state before the extract.


next up previous contents index
Next: 10 Interacting with Other Up: 9 Shortcuts and Tools Previous: 9.4 Sort

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999