Filtering records in DBF File

To specify a filter for the list of records, open Tools | Set Filter menu, or click the corresponding icon on the toolbar.

Filter dialog box opens.

To disable the filter, click Tools | Remove Filter, or click the corresponding icon on the toolbar.

Set the criteria for necessary fields and click OK.

Buttons "Save" and "Load" in the filter form allows you save and load queries.

Only the records meeting your criteria will be displayed. View the number of the filtered records in status bar, Records item.

To use Quick Filter you need to move pointer on the field, right-click and select Quick Filter from context menu

To save this records, select menu item File | Save As/Export  (Export dbf files to other formats)

See also: DBF to XLS, DBF to SQL, DBF to CSV,   Sorting records in dbf file, Command line options

To delete this records, select menu item Edit | All | Delete