Filter

On the File tab, in the Filter group:

• On the File tab, in the Filter group: Select Create to create a file filter. Filters are used to create subsets of your data. They are constructed by setting conditions that control which data is used from a data set.

• On the File tab, in the Filter group: Select Subset File to generate a new file from the selected records of an existing file. The records from the source file are selected based upon a predefined filter and then written to a new output file.

  You can optionally create a second file containing exceptions i.e. all the records that do not pass the filter.

• On the File tab, in the Filter group: Select Delete to delete records from a file based upon a set of filter conditions. The function immediately deletes the selected records.

Additional filter options are available on the File | File Editor tab, in the View group, when a file is open in the editor and on the File | Lookup Table Editor tab, in the Filter group when a Lookup Table is open. See: Filter.