Re: Sort CSV file within Excel based on specific column


laziness, impatience, and hubris
	PerlMonks

Re: Sort CSV file within Excel based on specific column

by runrig (Abbot)

on Oct 11, 2012 at 20:34 UTC ( #998537=note: print w/ replies, xml )

Need Help??

in reply to Sort CSV file within Excel based on specific column

No need to open a CSV file in Excel. Use Text::CSV/Text::CSV_XS. Read read the lines, put then in a hash keyed by your sort column, sort the keys, and print the lines.

Comment on Re: Sort CSV file within Excel based on specific column
Re^2: Sort CSV file within Excel based on specific column by Kenosis (Deacon) on Oct 11, 2012 at 21:05 UTC
...put then in a hash keyed by your sort column... Done this way, wouldn't the OP lose a csv row if two entries from the sort column are the same?	[reply]
Re^3: Sort CSV file within Excel based on specific column by runrig (Abbot) on Oct 12, 2012 at 00:28 UTC
Yes, I suppose the hash is unnecessary.	[reply]

In Section Seekers of Perl Wisdom

Node Status^?

node history
Node Type: note [id://998537]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others scrutinizing the Monastery: (4)

As of 2013-05-25 03:18 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

The best material for plates (tableware) is:

Results (516 votes), past polls