Sum a column

Accumulate a numeric column and print total

awk '{sum += $4} END {print sum}' access.log
tool
awk15 commands
tags
awklinux

More awk commands

  • Print lines between two patterns
    awk '/START/,/END/' file.txt

    Range pattern: include lines from START to END inclusive

  • Skip header line
    awk 'NR>1 {print $1, $2}' data.csv

    Process all lines except the first (header)

  • Count occurrences per key
    awk '{count[$1]++} END {for (k in count) print count[k], k}' access.log | sort -rn

    Frequency count of the first field (e.g. IP addresses)

  • Print last field
    awk '{print $NF}' file.txt

    NF holds the number of fields; $NF is the last field

  • Multi-condition filter
    awk '$2 > 500 && $5 == "POST"' access.log

    Print lines where field 2 > 500 AND field 5 is POST

all 15 awk commands