Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Sort CSV file within Excel based on specific column

by Kenosis (Priest)
on Oct 11, 2012 at 21:15 UTC ( #998554=note: print w/ replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    REVIEW_DATE,AUTHOR,ISBN,DISCOUNTED_PRICE
    1985/01/21,"Douglas Adams",0345391802,5.95
    ...
    2003/09/30,"Scott Adams",0740721909,4.95
    2004/10/04,"Benjamin Radcliff",0804818088,4.95
    2004/10/04,"Randel Helms",0879755725,4.50
    
  2. or download this
    use strict;
    use warnings;
    ...
    open $csvfh, '>', "sorted_$csvFileName" or die $!;
    $csv->print( $csvfh, $_ ) for @csvLines;
    close $csvfh;
    
  3. or download this
    REVIEW_DATE,AUTHOR,ISBN,DISCOUNTED_PRICE
    2004/10/04,"Randel Helms",0879755725,4.50
    ...
    2002/06/23,"David Jones",0198504691,9.95
    2002/06/23,"Julian Jaynes",0618057072,12.50
    1998/07/15,"Timothy ""The Parser"" Campbell",0968411304,18.99
    
  4. or download this
    { $a->[3] <=> $b->[3] }
    
  5. or download this
    { $a->[5] <=> $b->[5] }
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://998554]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (14)
As of 2014-07-31 21:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (253 votes), past polls