topic Re: Adding up columns in Operating System - HP-UX

Adding up columns

Dave Walley — Tue, 06 Jun 2000 15:35:56 GMT

Hi.

I have to write a script to total a column of numbers. For example I want to total the first column. I am using a csh to get the data up to this point.

3497796 /dbs
3479374 /dbs2
5799894 /dublin
440128 /dublin2

Any help

Dave

Re: Adding up columns

Francisco J. Soler — Tue, 06 Jun 2000 16:22:51 GMT

You can use the awk. For example.
awk 'BEGIN {total=0} {total+=$1} END {print total}' filein

You can redirect the stdout to another file.

If you want to print out all stdin you can modify the script and type in something like:

awk 'BEGIN {total=0} {total+=$1 ; print } END {print total}' filein

I hope this helps.

Re: Adding up columns

Brian M. Fisher — Tue, 06 Jun 2000 16:49:48 GMT

You can also do the following for nicer output:

commands | awk 'BEGIN {total=0}{total += $1}
END {printf("%.2f Gign",total/(1024*1024))}'

XXX.XX Gig

Brian
<*(((>< er

Re: Adding up columns

Brian M. Fisher — Tue, 06 Jun 2000 16:53:17 GMT

I made a typing mistake, it should be Gign instead of Gign

Brian
<*(((>< er

Re: Adding up columns

Brian M. Fisher — Tue, 06 Jun 2000 16:55:31 GMT

The problem seems to be the backslash does not transfer to the postings:

It should be Gig"backslash"n

Brian
<*(((>< er

Re: Adding up columns

Alan Riggs — Tue, 06 Jun 2000 19:27:16 GMT

The aboce replies are correct. For simplicity, though, the BEGIN, END, and initialization statements are not required. You can simply do:

| awk 'total+=$1 {print total}'

(note: this provides a running total. You do need the END statement (or a pipe to tail -1) if you want only the final total.)

ex: bdf|awk 'total+=$3 {printf("%.2f Gig|n",total/1024/1024)}'
provides a total of disk space used on a system. (note: |==backspace in the above.)