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
Export DBF to MySQL
DBF File Optimization
Commands
File
Edit
View
Tools
Options
Information
Support
How to purchase
Top  Previous  Next

Delete records in DBF file


Download

To delete records by searching in the specified field, click Edit | Delete Records. Delete records dialog box opens.

Delete records in DBF File

You may delete/recall a single record.


To delete the record in dbf file, select it and select menu command Edit | Delete/Recall Record menu, or click the corresponding icon on the toolbar. The deleted record will be marked with the red sign embim1


To restore the deleted record, select it and repeat the same action. 


To permanently remove all deleted records, click Edit | Pack




To delete duplicates, click Tools | Delete duplicates.

To delete empty records, click Tools | Delete empty records.

To recall deleted records, click Edit | Recall records.

To permanently remove record, click Edit | Remove record

 

To delete all records starting from a selected record, select the record that you want to be the last one, and click Edit | Truncate. Confirm your choice. All records below the selected record will be permanently removed.

To clear the entire file, click Edit | Zap. All records will be removed.

Download DBF Viewer and Editor

Updated Wed, 22 Nov 2017

Delete records via Command Line

"c:\Program Files\DBF Viewer 2000 (x86)\dbview.exe" file.dbf /delete:First,Last | /delete /filter:file

Delete records in range

"c:\Program Files\DBF Viewer 2000 (x86)\dbview.exe" mybase.dbf /delete:1,100

Delete records by filter

"c:\Program Files\DBF Viewer 2000 (x86)\dbview.exe" mybase.dbf /delete /filter:myfilter.txt

 

See also: Export DBF to XLS, Export DBF to CSV, Export DBF to XML, Export DBF to SQL

Back to DBF Viewer 2000 Home

Copyright © HiBase Group, 2002-2017