January 6, 2024

Multiply field’s (column’s) entries and sum them up with awk

$ awk '{ sum = sum + $2 * $3 } END { print sum }' file.txt 

You can write this command more concisely by using the abbreviation += for incrementing sum¹:

$ awk '{ sum += $2 * $3 } END { print sum }' file.txt 

Let me know if this command can be shorten: https://yctct.com/contact

---

1. The AWK Programming Language, Second Edition, Aho, Kernighan, Weinberger↩︎

✍✍✍✍✍✍✍✍✍✍✍✍✍✍

I do self-funded research and I'm writing a book.

> What's the book about?

About technologies and agency.

Meaning, technologies can foster agency. No doubt. But I am also asking:

Can usage of technologies give us a sense of empowerment while in fact undermining our abilities?

I posted a summary of the prologue on the homepage: https://yctct.com/

✍✍✍✍✍✍✍✍✍✍✍✍✍✍

personal computing command-line interface (cli) gnu linux trisquel shell literacy office applications wiki text processing awk spreadsheet stuff in the terminal