[ale] sorting large delimited text files

[Greg Freemyer]

On 7/6/05, Preston Boyington <PBoyington at polyengineering.com> wrote:
> I have some text files that I need to sort.  Each file is (roughly) 2200 pages (134,000+ rows) of comma delimited text.
> 
> the text looks like so:
> 2117496.796445,882112.506031,483.908997
> 
> I have tried to import these into OOo (1.0.4) and Excel (2000) spreadsheets, but keep hitting their limit on row count (32000 for OOo and about 65000 for Excel).
> 
> Most likely I will have to sort the files by the third column / number (initially at least).
> 
> How else can I sort these files quickly?
> 
> Thanks,
> Preston
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
> 

Have you tried good old "sort".

Something like "sort -n -k 3 -t=, your_file > your_sorted_file" should work.

Greg
-- 
Greg Freemyer
The Norcross Group
Forensics for the 21st Century