topic Re: awk query in Operating System - HP-UX

awk query

Declan Mc Kay — Fri, 28 Nov 2003 09:04:31 GMT

Hi,

I want to total up the 5th Column of a text file. However, the total being printed is not printing/displaying in the correct format..I think my total is working fine but my printf is missing something..as follows:
cat $TRAFFIC | awk '{t1 +=$5}
END {printf("TRAFFIC TOTAL: "t1"")}' >> $TRAFFIC

Printf outputs as follows: e.g.
TRAFFIC TOTAL: 5.97367e+06

I think this is because the total will be quite a large number...I don't know how to display this correctly..?

Also, I want to convert & display this value from bytes into kb's & mb's...Any easy method anyone?

Re: awk query

Elmar P. Kolkman — Fri, 28 Nov 2003 09:06:57 GMT

You could try:
printf("Traffic total: %d",t1);

Re: awk query

Jean-Luc Oudart — Fri, 28 Nov 2003 09:07:51 GMT

try
printf("TRAFFIC TOTAL %12d\n",t1)

Rgds,
Jean-Luc

Re: awk query

Jean-Luc Oudart — Fri, 28 Nov 2003 09:10:33 GMT

for more on printf

man printf

Rgds,
Jean-Luc

Re: awk query

Mark Grant — Fri, 28 Nov 2003 09:13:11 GMT

You need something like

printf "TRAFFIC CONTROL %ld",t1

The simplest way to get your other answers is to divide by 1024 :)

Re: awk query

Michael Schulte zur Sur — Fri, 28 Nov 2003 09:13:40 GMT

Hi,

you use printf, but provide no format string to format the number. You can print with or without leading zero and formatted to a specified number of digits.

{printf("Total %09d \n",t1)}

Nine digits with leading zeroes and newline.

greetings,

Michael