List to columns and awk help - Shell Programming and Scripting

ranj@chn · #2 (**permalink**) 08-27-2007

Code:

awk -v var=4 -f sample.awk inputfile

where sample.awk is

Code:

(NR % var ) == 0 { sum+=$0; cnt++}
END {print sum, cnt }

This adds every 4'th element is the list.

If you want the count starting from the first column in the list, change the sample.awk to

Code:

BEGIN { row_cnt=1 }
(NR % row_cnt ) == 0 { sum+=$0; cnt++; row_cnt+=var }
END {print sum, cnt }