AWK passing output, line by line to variable..

[Tarantulus]

Hi guys,

ok this is a tough one to explain, but I'll try my best:

I have a CSV file in the format "$date,$val ue"

what I want to do, is work through the file line by line (I guess piping through AWK to get $date and $value), and while $date does not change add $value to a running total $total$i

when $date changes $i increments so $total$i is a new variable ($total1 becomes $total2)

does this make sense and is it possible?

thanks in advance

[radoulov]

Please provide sample input and example of the desired output.

[Tarantulus]

sample input:

11/01/2008,312
11/01/2008,200
12/01/2008,600

sample output:

total1 = 512
total2 = 600

OR

11/01/2008 - 512
12/01/2008 - 600

Thanks

[radoulov]

It the date column is sorted:
(use nawk or /usr/xpg4/bin/awk on Solaris)

awk -F, 'END { print d, t }
!_[$1]++ && d { print d, t; d = t = "" }
{ d = $1; t += $2 }' OFS=\\= filename

[Tarantulus]

Thanks a lot,

I actually worked it out myself (in a much more convoluted way) but your way is much prettier :)