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
Export dbf files
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 order DBF Editor
Top  Previous  Next

Sorting DBF File


Download

You may sort the records in dbf file of any field in ascending or descending order.




To set the ascending sorting order, i.e. A to Z, the smallest to the largest, oldest to youngest, - right-click and select Ascending command. 


To set the reverse sorting order, right-click and select Descending

To perform more sophisticated sorting, click Tools | Advanced Sorting menu, or click the corresponding icon on the toolbar. Advanced Sorting dialog box opens.

Sort DBF file

Using right and left arrows, compose the list of fields for prioritized sorting and select Ascending or Descending radio button. To clear the list, click Unselect All.

To set case-insensitive mode, i.e A=a, select "Ignore case" option.

To export records with sort order, select menu item File | Export dbf files  (export dbf files to other formats)

To save sort order in this file, select menu item File | Save order

Sort records via Command Line

"c:\Program Files\DBF Viewer 2000 (x86)\dbview.exe" unsorted.dbf /export:sort.dbf /SORTBY:ORDER [/ignorecase]

Download

Updated Wed, 22 Nov 2017

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