Ljackson at 23:02, 6 February 2008

Ljackson — Wed, 06 Feb 2008 23:02:58 GMT

New page

Do you (still) need to sort plain text files with DOS, WINDOWS, UNIX, MAC (or even mixed!) end-of-line marks? Or files with fixed-length records? Then you should take a look at CMSort, a freeware command line sort utility for Windows 95/98/NT/2000/XP.

== Usage ==

<pre>
CMsort version 1.6 - Sort a DOS, WINDOWS, UNIX, MAC, or mixed text file
(c) 2002 Christian Maas (chmaas@handshake.de www.chmaas.handshake.de)
Currently available physical memory: 998,760,448 bytes
Usage: CMsort [sort field] ... [option] ... <input file> <output file>
Sort fields: /S=F,L string from position F with length L (case sensitive)
/C=F,L string from position F with length L (case insensitive)
/N=F,L numeric from position F with length L
Notes: 1. The complete line is used as sort field when running
CMsort without indicating sort fields.
2. Use L=0 for the last non-numeric sort field to define
a (part-) key until end of line.
Options: /F=n read/write files with fixed-length records (n byte without CR/LF)
/B ignore blank or empty records
/D ignore records with duplicate keys (according to sort fields)
/D=<file> ignore records with duplicate keys, write them to <file>
/Q quiet mode (no progress output)
/H=n don't sort n header lines (default: n=0)
/W=n n-way-merge of temporary files (2<=n<=5, default: n=5)
/T=<path> for temporary files (/T=TMP for Windows temporary file path)
/M=n[p] use n KB [or n% of physical available] memory;
default: use 10%, at least 100 KB, but max. 1024 KB
otherwise: use as indicated, but at least 100 KB
Use CMsort /E to show examples.
</pre>

== Merging CSV Files ==

The following line will merge all .csv files into the output.csv file.

type *.csv > output.csv

== Sorting CSV Files ==

The following line will preform a ascending numerical sort on the input file.

CMsort.exe /N=5,13- /B input.csv output.csv

=== Removing Duplicates ===

The following line will preform an ascending numerical sort on the input file and remove any duplicates.

CMsort.exe /N=5,13- /B /D input.csv output.csv

== Sources ==

* http://www.chmaas.handshake.de/delphi/freeware/cmsort/cmsort.htm

[[Category: Windows XP]]

CMsort - Revision history

Ljackson at 23:02, 6 February 2008