Listing Items Not Included in a Select-list (NSELECT)

NSELECT may be used only when another select-list is currently active. Therefore, NSELECT must be used immediately after a select-list has been created with one of the list-creating commands or reactivated with GET-LIST. NSELECT creates a second select-list of only those items in the active select-list that are not in the file specified by the NSELECT statement.

Format

NSELECT filename

Examples

The next example creates a select-list of all of the items in the ORDERS file, then creates a second select-list from the items on this list that are not in the ORDERS.PAID file. The result is a list of those items in the ORDERS file that are currently unpaid:

>SELECT ORDERS

347 ITEMS SELECTED.

>NSELECT ORDERS.PAID

256 ITEMS SELECTED.

>

The unpaid order items may then be listed with this query:

>LIST ORDERS

At this point, the REFORMAT command (described in the previous section titled Using INFO/ACCESS Commands for Special Processing) might be used to write these selected items to a file called OVERDUE.ORDERS.

See Also

Creating Select-lists

Creating a Select-list (SELECT)

Selecting Items that Contain a String (FIND)

Creating a Select-list from Data (QSELECT)

Selecting a Specified Number of Items (SAMPLE)