DBF Viewer 2000
DBF Viewer 2000 Online Help Prev Page Prev 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
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
Download DBF Viewer and Editor Top  Previous  Next

Search in DBF file

Download

You may searching for records meeting the specified parameters.

To set criteria for searching records, click Edit | Find menu, or click the corresponding icon on the toolbar. Find dialog box opens.

Find in DBF File

Set the criteria for necessary fields and click OK.

To find next entry, click Edit | Find Next menu, or click F3.

You can use the following meta symbols in search expressions:

 


?-any character in current position 


*-any characters after '*' 


*aa- search "aa" in any position 




 

Example

Matches

Doesn't Match

ab*

abc

cab

a?b*

aabc

aadc

*ab

cab,abc

cba

 

 

 

Macros empty() allows find records with empty fields

! find with not equal value

Example: !Peter

records with field not equal Peter

!empty()

records with not empty field.

 

multiple search criteria:

peter or john or mike

 

You can also set range for date/Timestamp fields and all numeric types.

 

Download

Updated Thu, 30 Mar 2017

See also: Filtering records, Sorting records in dbf file, Command line options

Back to DBF Viewer 2000 Home

Copyright © HiBase Group, 2002-2017