Delete

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.

To view the records selected in the file (and ensure that the correct records will be deleted), set the filter, then right-click in the File input box and select Edit from the right-click menu.

File

Double-click (or click on the Select icon) to select the name of the file you want to delete records from.

Filter number

Enter the number of the Filter you want to apply. To see a list of available filters double-click, or to set up a new filter, right-click or use the Expression icon to open the Expression Editor.

There is no filter check box. When you use the Delete function the use of a filter is compulsory.

Run

Click Run. The records that match the filter are deleted from the original file.