Delete records in DBF file

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

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.
• 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.

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

Copyright © HiBase Group, 2002-2019