sorting .csv files

Kevin Corr · Post by **Kevin Corr** » Tue Dec 14, 2004 7:01 pm

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

Post by **MudGuard** » Tue Dec 14, 2004 7:23 pm

load your csv into a spreadsheet program (OpenOffice Calc, Excel, ...) (most support importing/exporting csv), sort it, save it ...

Kevin Corr · Post by **Kevin Corr** » Tue Dec 14, 2004 8:18 pm

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?

Ed · Post by Ed » Tue Dec 14, 2004 8:46 pm

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.

talleyrand · Post by **talleyrand** » Wed Dec 15, 2004 5:29 pm

There's always Access, it'll work fine to import files that Excel/OO can't handle.

ceric · Post by **ceric** » Wed Dec 29, 2004 8:27 pm

A very easy way would be a simple programs that loads CSV values into memory and sorts it as a multi-dimensional array

Community