Shell Programming and Scripting

Hi All
I want to make summery for

Date=245Duration=545
Date=245Duration=10
Date=245Duration=278
Date=246Duration=30
Date=246Duration=178
Date=246Duration=414
Date=247Duration=17
Date=247Duration=281
Date=247Duration=9
Date=248Duration=968
Date=248Duration=550
Date=248Duration=1011
Date=248Duration=1659
Date=249Duration=415
Date=249Duration=230
Date=249Duration=142
Date=249Duration=600
Date=250Duration=413
Date=250Duration=86
Date=250Duration=821


-----last figuer in millisecounds and round to secounds
(ex -545 = 55 ,10 = 1 , 278 = 28 and tot is 84)
The answer should be like following

Date=245 84
Date=246 62
Date=247 39
Date=248 389
Date=249 513
Date=250 210

Thanks


I try to use

for i in `cat k`
do
aa=`echo $i |cut -d ',' -f1`
bb=`echo $i |cut -d ',' -f2`
echo $aa `echo $bb |cut -d '=' -f2|sed 's/\(.*\)\(.\)/\1.\2/'|awk '{print int($1+0.5)}'` >> duration_qc
done

Code:

awk -F= '{a[$1"="int($2)]+=int(($3/10)+0.5)}END{for (i in a)print i " " a[i]}' file

Use nawk or /usr/xpg4/bin/awk on Solaris.