Page 1 of 1
sorting .csv files
Posted: Tue Dec 14, 2004 7:01 pm
by Kevin Corr
Hi all...
I am looking for suggestions on how to sort on different fields in .csv formatted files where the length of row differs fro row to row.
Thanks
Posted: Tue Dec 14, 2004 7:23 pm
by MudGuard
load your csv into a spreadsheet program (OpenOffice Calc, Excel, ...) (most support importing/exporting csv), sort it, save it ...
sorting .csv files
Posted: Tue Dec 14, 2004 8:18 pm
by Kevin Corr
Thanks for your response. I should have been more specific and mentioned that these are larger than the standard Excell spreadsheet can handle (ie greater that 65,536 lines).
Other thoughts?
Posted: Tue Dec 14, 2004 8:46 pm
by Ed
What I have done successfully before is:-
Convert , to <tab>
create a document class with tab set wider than your widest field
open the csv file into this document class and then use TextPad to sort it.
Posted: Wed Dec 15, 2004 5:29 pm
by talleyrand
There's always Access, it'll work fine to import files that Excel/OO can't handle.
CSV Sorting
Posted: Wed Dec 29, 2004 8:27 pm
by ceric
A very easy way would be a simple programs that loads CSV values into memory and sorts it as a multi-dimensional array