Excluding records from display

You can hide records from your view, by excluding records that have some common factor.

To exclude multiple records based on a common factor:

EXCLUDE commands are cumulative; each successive EXCLUDE command increases the number of records already excluded.

To “unexclude” (redisplay) excluded records:

After you have excluded records, you can limit the effects of the FIND, FE, SHADOW and SORT commands to only those records that are excluded or only those that are not-excluded. You do this by including one of the following option parameters with the primary command:

X or EX
Affects only excluded records
NX
Affects only not-excluded records

For example, the following command finds all occurrences of the string “no”, “No”, “NO”, or “nO” in all not-excluded records:

FIND NO ALL NX
Note:
  1. If neither parameter is used with the primary command, both excluded and not-excluded records are affected.
  2. If an excluded record is affected by a primary command, either by using the EX parameter or by not specifying an EXCLUDE parameter, the record becomes not-excluded.

Related topics