Count column data in a text file

alegnagrp · December 20, 2012, 6:27am

I have a text file that has the following column data:

0.007
0.005
0.004
0.007

How do i output the total sum of the data above?

Jairaj · December 20, 2012, 6:44am

Try this:

awk '{sum+=$1} END {print sum}' file

sathyaonnuix · December 20, 2012, 6:47am

Try this:

cat file | awk '{ sum+=$1} END {print sum}'

rangarasan · December 20, 2012, 7:01am

You have won "Useless use of cat award"!!!!!

alegnagrp · December 20, 2012, 7:01am

thanks all.

sathyaonnuix · December 20, 2012, 7:15am

Thanks Rangarasan. I will take this as a part of motivation and correct my mistakes.

To err is human

rangarasan · December 20, 2012, 8:32am

All is well Good spirit