[SOLVED] table management with awk

shruggy · 04-30-2020, 11:45 AM

Quote:

Originally Posted by Drosera_capensis

So, back to my first question: would anyone know how to make an array equivalent to $2+$3+$4+$5?

What for? It's awk, it's neither Excel nor APL. If you want to summarize all elements of an array with a function, you have to write that function yourself.

Drosera_capensis · 04-30-2020, 12:06 PM

I thought there was a simple way to write $2+$3+$4+$5 in awk, the equivalent of {2..5} for bash as quoted shruggy.

But you wrote that awk is not able to do it, and a for loop has to be used to get this done.

In this case, the answer could be:

Quote:

awk 'NF { for(i=2;i<=5;i++) {sum=sum+$i} { print sum/NR } }' table

Thanks for the help.