Search in DBF file

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.

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
• b$ - match b at end of field

Example	Matches	Doesn't Match
ab*	abc	cab
a?b*	aabc	aadc
*ab	cab,abc	cba
a*b$	acb	abc

Macros empty() allows you to find records with empty fields

! find with not equal value

Example: !Peter

records with field not equal Peter

!empty()

records with not empty field.

Macros substrblank() allows you to find records with blank spaces in fields

!substrblank()

records that do not contain any blank spaces

multiple search criteria:

peter or john or mike

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

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

Back to DBF Viewer 2000 Home