No such thing as a small change | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Hi,
Here is what I am trying to do. Read the CSV (excel sheet saved as a comma separated file) file into a perl data structure (either hash of array OR array of arrays). And sort based on one of the columns. When this is done, I want the rest of the columns too to be re-ordered based on the sorted column. That is the columns of a row must remain same. For eg: This is the CSV file. Name,Score,State Mike,67,CA Rob,63,FL Jim,72,IL Chan,32,AZ When this is read into a perl data structure, and suppose I sort the column for Score in ascending order, I want the rest of the fields corresponding to the column to be re-ordered. So the result should be Chan,32,AZ Rob,63,FL Mike,67,CA Jim,72,IL 1. What data structure is best suited for above? 2. And how to achieve the above? Thanks in advance. In reply to sorting CSV files by Anonymous Monk
|
|