Filter the Data File

In the Navigation group, click (Filter).
The Filter dialog box appears.

Filters are constructed by adding one or more conditions.
Click New Ref.
The basic reference elements appear.
In the Field fields, enter 10 as the start position, and 3 as the number of positions on from that in which to filter within each record.
Ensure the Operator field is set to =.
In the Value field, enter "mr".

Note: Ensure that you include the space shown at the end of the string.
Click New Field.
The basic field elements appear.

Note: The New Field option is only available when a structure file has been applied to the data file.
Click to the right of EM-POSITION and select MN-AGE.
Change the Operator field to <.
In the Value field, enter 40.
Ensure Match All is selected.
This means that only records that match both criteria are displayed.
Click Filter.
The results filter on the records for all males that are managers under 40 years of age:
To display all records again, click in the Records group and select All.
The entire data file appears.