Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
output based on 2 unique columns
Hi everyone, I have got different files in a directory. Dir1: File 1 File 2 Sample Input Data: File 1 $key,$No,$date,$time,$price,$units,$flag A,1,2010-06-07,93002,10,100,Y A,1,2010-06-07,153002,10,200,Y B,2,2010-06-07,93002,10,100,Y B,2,2010-06-07,153002,10,200,Y B,2,2010-06-09,93002,10,100,Y... -
group by one column and then calculate net value of another column
Hi, I need some help with perl code for the below: Input data: $Date,$Mod_Time,$Index,$Date_Inst,$Time_Inst,$Reason,$In,$Phase,$Type,$BuyorSell,$Size,$Price 20100611 090009.870000 2 20100611 85954 5 Tes C L -1 16 43.85 20100611 090009.870000 2 20100611 90009 4 Tes C L 1 16 3.85 20100611... -
for each unique value in a column find the max value..need perl script
Hi, Below is my Input file: date mtime no size id day order 20100607 154538.354300 200 1 101510 14098703993 20100607 154539.420000 200 1 101511 14098703993 20100607 154538.398200 487 1 100888 14098703994 20100607 154610.720000 487 1 91588 14098703994 20100607 154538.401200 200 1 101502...
