About awk command

incomingid · 04-01-2009, 05:15 PM

I am trying to add row $2 to find the total.

Ex.
File.txt
Age 21
Age 31
Age 13
Age 20

I want to use awk command to get the age total ( in this case it would be 85)

anomie · 04-01-2009, 06:09 PM

There's a number of ways to handle this, but what I would do is:

Code:

$ awk '{ sum = sum + $2 } END{ print sum}' data-file

There's a free online gawk book that you should read if you don't understand what that is doing. (It's a good reference to keep bookmarked as well.)

incomingid · 04-01-2009, 08:53 PM

Thanks alot.

incomingid · 04-01-2009, 09:06 PM

I tried your command and i get the following error:

awk: {total = total + $2) END{ print sum}
awk: ^ syntax error
awk: cmd. line:1: {total = total + $2) END{ print sum}
awk: cmd. line:1: ^ unexpected newline or end of string

incomingid · 04-01-2009, 09:10 PM

Sorry, i found the error there, but the output of that command is 0.

Tinkster · 04-01-2009, 10:44 PM

Code:

awk '{total+=$2}END{print total}' file

works here ...
Maybe your file looks different from what you posted?