[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] sorting large delimited text files
- Subject: [ale] sorting large delimited text files
- From: greg.freemyer at gmail.com (Greg Freemyer)
- Date: Wed Jul 6 16:15:16 2005
- In-reply-to: <ED82B8B59EA2D44C9E64E228028E4B34029D01@poly_ethylene.corp.polyengineering.com>
- References: <ED82B8B59EA2D44C9E64E228028E4B34029D01@poly_ethylene.corp.polyengineering.com>
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