topic Re: totalling columns in a script in Operating System - HP-UX

totalling columns in a script

miracle — Thu, 15 May 2003 00:12:53 GMT

I am trying to total some columns from some output from an EMC command in a file.
Here is the output.

D E V I C E G R O U P S

Num of Num of Num of
Name Type Valid Symmetrix ID Devices GK's BCV's

goanna1_rdf RDF2 Yes 000285502576 18 0 18
koala1_rdf RDF1 Yes 000285502576 70 0 0
snake11_rdf RDF1 Yes 000285502576 26 0 0
beaver4_rdf RDF1 Yes 000285502576 5 0 0
trouser1_meta REGULAR Yes 000285502576 1 0 0
monster1_meta1 REGULAR Yes 000285502576 1 0 1
beaver2_reg REGULAR Yes 000285502576 4 0 0

I can total one column using:
$ awk 'BEGIN {total +=5;}
> END {print "Total ",total}' inputfile >outputfile

When I try to use a similar method it gives a strange total
$ awk '{F5=F5+$5;F6=F6+$6;F7=F7+$7};END {print F5,F6,F7}'inputfile
3787 458 03787 458 0

What I really want is totals for each of the last three columns with the numbers appearing underneath.
AWK would be preferable but any ideas to solve the problem will get you points.

Re: totalling columns in a script

Michael Steele_2 — Thu, 15 May 2003 00:23:31 GMT

COL5=0
COL6=0
COL7=0
cat file | while read a b c d e f g
do
COL5=$(($e+$COL5))
COL6=$(($f+$COL6))
COL7=$(($g+$COL7))
done

Re: totalling columns in a script

miracle — Thu, 15 May 2003 01:11:09 GMT

When I try this I get the totals correctly but the formatting is not where I want it.
I want to append to the same input file.

$ awk '{t1 +=$5;t2 +=$6;t3 +=$7}
> END {print "Total "t1 ,t2 ,t3}' input file >>inputfile

Thanks Michael for your suggestion but it gives an error:
C+0: bad number

Re: totalling columns in a script

S.K. Chan — Thu, 15 May 2003 01:23:35 GMT

Try this instead ..
$ awk '{F5=F5+$5;F6=F6+$6;F7=F7+$7;} END {print "total:", F5,F6,F7}' inputfile
You got a bit of syntax problem in your original awk statement. I did not test this but I think it should work.

Re: totalling columns in a script

miracle — Thu, 15 May 2003 01:30:19 GMT

Thanks Mr SK,
I had already worked that part out. I have since got it to work using this, but there must be a better way to format using spaces, which is what I've done.

cat /tmp/myfile| awk '{t1 +=$5;t2 +=$6;t3 +=$7}
END {printf("Total %d %d %d\n",t1,t2,t3)}' >>/tmp/myfile

Re: totalling columns in a script

miracle — Thu, 15 May 2003 02:34:55 GMT

In between each of the %d entries, there are number of spaces included to place the totals under columns 5, 6 & 7. Is there a better way?

I don't care if I have to use something else. ... perl ... ? please help

Re: totalling columns in a script

S.K. Chan — Thu, 15 May 2003 03:12:02 GMT

You can pad the field with a specify width to get the format you wanted. For example ..

$ cat /tmp/... END {printf("Total 5%d8%d10%d\n",t1,t2,t3)}' .....

and you would get this output.

Total<4 spaces>125<7 spaces>0<9 spaces>19

Re: totalling columns in a script

miracle — Thu, 15 May 2003 03:50:18 GMT

Mr SK

That does not help, it now prints my total line as

Total 5125801019

Re: totalling columns in a script

Michael Tully — Thu, 15 May 2003 04:07:54 GMT

Try it this way, by placing the number and % and numerals like this.

e.g.

cat file | awk '{t1 +=$5;t2 +=$6;t3 +=$7}
END {printf("Total %50d %8d %8d\n",t1,t2,t3)}' >>file

The padding for the spacing of the numbers has to be after the % sign not before.

Regards
Michael
"When I have trouble spelling, it's called fat finger syndrome"

Re: totalling columns in a script

miracle — Thu, 15 May 2003 09:12:21 GMT

That works great, I was just wondering if there was a perl solution for this? Can someone help me?

Re: totalling columns in a script

Robin Wakefield — Thu, 15 May 2003 09:58:49 GMT

Well here's one way:

perl -ape '{$a+=$F[4];$b+=$F[5];$c+=$F[6]}END{printf("Total %50d %8d %8d\n",$a,$b,$c)}' yourfile

rgds, Robin

Re: totalling columns in a script

Mike Miller_8 — Fri, 16 May 2003 13:20:07 GMT

simply run the awk program provided using the command

awk -f file.awk filename > outputFile

I think this will generate what you want.

= Mike =

Re: totalling columns in a script

miracle — Sun, 18 May 2003 20:45:59 GMT

Thanks Robin for the perl script, that too works well. Thanks Mike for your script as well, but I was trying to limit the padding for the spaces. This case is closed.