sorting .csv files

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
Kevin Corr
Posts: 2
Joined: Tue Dec 14, 2004 6:50 pm

sorting .csv files

Post 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
User avatar
MudGuard
Posts: 1295
Joined: Sun Mar 02, 2003 10:15 pm
Location: Munich, Germany
Contact:

Post by MudGuard »

load your csv into a spreadsheet program (OpenOffice Calc, Excel, ...) (most support importing/exporting csv), sort it, save it ...
Kevin Corr
Posts: 2
Joined: Tue Dec 14, 2004 6:50 pm

sorting .csv files

Post 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?
Ed
Posts: 103
Joined: Tue Mar 04, 2003 9:09 am
Location: Devon, UK

Post 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.
User avatar
talleyrand
Posts: 624
Joined: Mon Jul 21, 2003 6:56 pm
Location: Kansas City, MO, USA
Contact:

Post by talleyrand »

There's always Access, it'll work fine to import files that Excel/OO can't handle.
I choose to fight with a sack of angry cats.
ceric
Posts: 6
Joined: Wed Dec 29, 2004 8:24 pm
Contact:

CSV Sorting

Post 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
Post Reply