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