Sum up all values of a column in a text file

Recently, I had to sum up all integers of a column in a text file (similar to how you do in excel). After some digging up, I came up with a awk one liner to do it.

Following my tradition of documenting one liners, I am going to document this one as well :)

Input and output data

Here is the super simplified version of input data that I was using.

I wanted to find the sum of all values present in the 3rd column. So in the case, the output that I was expecting was 145

Command

Here is the awk one liner, which does this.

Explanation

awk script is executed for each line and the first part of the command creates a variable s that stores the sum of all values in the 3rd column.

When the end of file is reached, the second part of the command is executed, which just prints the value of the variable.

Field separator

If the columns are separated by a comma or by any other non whitespace character, then you have to just specify it by adding FS=',' to the above command.

The more I dig deeper into awk, the more I like it and it is really fascinating to see how much you can do with this tool.

I learned a lot about awk and hopefully this teaches something to you as well ;)

Related posts

Tags: , ,

2 Comments so far

Trackback URI | Follow up comments through RSS Feed | Post a comment

  • bruno says:

    Here is a perl oneliner to keep you amused, here you go dude:

    perl -lane ‘$sum += $F[2]; END { print $sum }’ input.txt

    Fun trivia: there exist a bash one-liners (sort of ) way of acheieving this too……

Leave a Reply