Shell Programming and Scripting

Friends, I have a file with fileds in the following order

sda 4.80 114.12 128.69 978424 1103384
sdb 0.03 0.40 0.00 3431 0

sda 1.00 0.00 88.00 0 176
sdb 0.00 0.00 0.00 0 0

sda 1.00 0.00 88.00 0 176
sdb 0.00 0.00 0.00 0 0

Now what i want is to sum up the values in 2nd column 2 rows at a time like first sum will be 4.80 + .03. 2nd will be 1.00 + 0.00. and so on. Pls can u advice me how i can acheive this.

Pretty basic stuff. What have you tried so far ? Post your script over here.

tyler_durden

This is the script i developed. pls help me in correcting it out as i am new to awk.

i =`iostat -dt | egrep -v "Linux|Device|Time" | cut -d" " -f1 |wc -l`i=`expr $i - 1`
j=$i
echo $i
echo "enter Iterations"
read iterations
echo "enter interval"
read interval
iostat -dt $interval $iterations | egrep -v "Linux|Device|Time" > file





for ((a=1;a<=$iterations;a++))
do
head -$i file | awk ' { s += $2 } { values["'$a'"]=s } END { print "Sum", values["'$a'"]}'
i=`expr $i + $j` done

For the sum on the sample file given in your OP:

Code:

awk '{t+=$2}!((NR+1)%3){printf"%.2f\n",t;t=0}' file

But by guessing what you are trying to do in the above script, I think you can simplify it a lot. At least in the second part, after the user input. Piping head into awk is useless. awk can easily emulate head. Give us more input on file to process, like a typical output of command iostat that I don't have on my linux box.

NB: Please use the code tag (the # in your edit window).

Code:

$ 
$ cat f2
sda 4.80 114.12 128.69 978424 1103384
sdb 0.03 0.40 0.00 3431 0

sda 1.00 0.00 88.00 0 176
sdb 0.00 0.00 0.00 0 0

sda 1.00 0.00 88.00 0 176
sdb 0.00 0.00 0.00 0 0
$ 
$ awk '{if (/^$/){printf("%s %d => %0.2f\n","Sum",++n,sum); sum=0} else {sum += $2}}END{printf("%s %d => %0.2f\n","Sum",++n,sum)}' f2
Sum 1 => 4.83
Sum 2 => 1.00
Sum 3 => 1.00
$

tyler_durden

And yet another one:

Code:

awk -F" |\n" -v RS="" '{print $2+$8}' file

Your solutions (on my MacBook) displayed on the first line 4,00 and not 4,83 ???