Re: 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

Replies are listed 'Best First'.
Re^2: Sort CSV file within Excel based on specific column by Kenosis (Priest) 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]