DBF Viewer 2000
DBF Viewer 2000 Online Help Prev Page Next Page
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
How To
Export DBF to CSV
Export DBF to XLS (Excel)
Export DBF to XML
Export DBF to SQL
Delete duplicates
DBF File Optimization
How to purchase
Top  Previous  Next

Wide Filter

for FREE

Imagine a situation: you know that a certain dbf database contains some data, but you are not sure what field it is in. Too bad, the number of fields in the database is big enough to make this task look very unappealing.

And it's a totally different story with DBF Viewer 2000. It envisages a special function called Wide Filter and with it searching across all fields in a database is an absolute breeze. Here is how it works.

Step 1: Execute Wide Filter from the menu "Tools"

This will open up the filter window:

wide filter window

Step 2: Filter records

Now, type the value into the box to filter records in all fields. For example, if you enter "26400", DBF Viewer 2000 will filter out all records except those containing this value, no matter if it is numerical or string.

Moreover, you can exclude deleted records from the search or apply the filter to memo fields as well. Simply check the corresponding options.

Click OK when you are done, and DBF Viewer 2000 will apply the selected filter to the entire opened database. Needless to say, this is a lot easier than search for a value manually field by field.

Wide Filter Command Line

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

for FREE

Updated Mon, 18 Jan 2021

See also: Quick Filter, DBF File format, DBF File Optimization, DBF to XLS (Excel), DBF to SQL, DBF to CSV, DBF Repair Tool, Filtering recordsSorting records in dbf file, Command line options

Back to DBF Viewer 2000 Home

Page top |  Copyright © HiBase Group, 2002-2021