healingtao has asked for the wisdom of the Perl Monks concerning the following question:
Hello Monks, I have 2 csv files, each with 10 columns,(test1.csv and test2.csv) they both have the same headers and the first 3 columns are the key for each file. What is the quickest way to take column 4,5 and 6 from from test1.csv and replace these columns in test2.csv. It needs to be done by each row because you need to match each row by key because number of rows are different in each file. Thanks
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: replace columns in csv
by Tux (Canon) on Feb 12, 2015 at 08:41 UTC | |
|
Re: replace columns in csv
by i5513 (Pilgrim) on Feb 12, 2015 at 09:55 UTC |