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.
...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?
Priority 1, Priority 2, Priority 3
Priority 1, Priority 0, Priority -1
Urgent, important, favour
Data loss, bug, enhancement
Out of scope, out of budget, out of line
Family, friends, work
Impossible, inconceivable, implemented
Results (60 votes),