Re^4: how do I manipulate data in csv file

hi, sorry ya, i am newbie in perl

can i know what if i have a csv file like below?

 week    power   test     Test_end_date_time
201120   5        1       05-10-2011_16:47
201120   699      17      05-10-2011_16:48
201120   454      1       05-10-2011_16:49
201121   5687     26      12-10-2011_15:47
201121   211      1       12-10-2011_15:48
201121   1231     36      12-10-2011_15:49
201121   171      1       12-10-2011_15:50
201121   677      57      12-10-2011_15:51
201121   178      1       12-10-2011_15:52
 
if test = 1 mean pass, other than 1 is fail

I wish the output in another csv is like below, is it correct to use @
+field??

week   volume    yield
201120 3         66.7%
201121 6         50.0%
[download]

Comment on Re^4: how do I manipulate data in csv file Download Code

Replies are listed 'Best First'.
Re^5: how do I manipulate data in csv file by Anonymous Monk on Jul 26, 2011 at 14:06 UTC
Maybe if you ask one more time, you'll get a different answer?	[reply]