|
|
| Syntactic Confectionery Delight | |
| PerlMonks |
Re^3: Sort CSV file within Excel based on specific columnby Kenosis (Deacon) |
| on Oct 12, 2012 at 15:52 UTC ( #998731=note: print w/ replies, xml ) | Need Help?? |
|
Tanktalus provided excellent directions on how to achieve your goal. With just a little more work, the script I've shown you can accomplish these items. For example:
will skip all lines containing 'Outbound' in your shown data set. You can manipulate the row data right after next, to get what you need before pushing the line onto @csvLines. How do you want to separate Call Start Time and which three columns do you want to delete?
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||