Next: 10 Interacting with Other
Up: 9 Shortcuts and Tools
Previous: 9.4 Sort
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:
- Select Extract from the Tools menu. NExS displays
the Extract dialog box as shown in Figure 9.3.
- 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
.
- 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
- 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:
- To find values less than 20, specify the target
as
#<20
- To find values greater than or equal to 50,
specify the target as
#>=50
- 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
- To find the cell containing the date August 22,
1991, specify the target as:
#==@DATE(91,8,22)
- Click on the check button labeled Numeric Comparison
if you using a numeric find pattern.
- 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.
- Click Cancel to quit Extract.
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: 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