DBF Viewer 2000
DBF Viewer 2000 Online Help Prev Page Next Page
Introduction
Hotkeys
Command line options
Working with dbf files
Opening DBF files
Creating New DBF file
Modifying dbf file structure
Viewing statistics
Import/Append records
Save As/Export
Working with records
Adding records
Editing records
Deleting records
Replacing records
Filling records
Sorting records
Searching and Filtering
Searching by criteria
Filtering records
Quick Filter
Wide Filter
How To
Export DBF to CSV
Export DBF to XLS (Excel)
Export DBF to XML
Export DBF to SQL
Commands
File
Edit
View
Tools
Options
Information
Support
How to purchase
Top  Previous  Next

Filtering records in DBF File


DOWNLOAD
for FREE

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.

filter in dbf file

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

find-in-dbf-file

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

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

Filter via Command Line

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" database.dbf /EXPORT:filtered.dbf /FILTER:filter.txt

Example for filter.txt:

Name:*Jack
ID:>100


DOWNLOAD
for FREE

Updated Fri, 14 Apr 2023

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

Back to DBF Viewer 2000 Home

Page top | Contacts | Copyright © HiBase Group, 2002-2023