#columns
5 one-liners with this tag.
All one-liners tagged columns
Calculate the average, minimum and maximum of a column
$awk -v c=2 'NR == 1 {min = max = $c} {s += $c; if ($c < min) min = $c; if ($c > max) max = $c} END {if (NR) printf "n=%d avg=%.2f min=%s max=%s\n", NR, s/NR, min, max}' measurements.txt
Extract specific fields with cut
$cut -d':' -f1,7 /etc/passwd
Print lines where a column value exceeds a threshold
$awk -v c=10 -v min=5000000 '$c + 0 > min + 0' /var/www/vhosts/system/example.com/logs/access_ssl_log
Put two files side by side line by line
$paste -d ';' domains.txt ips.txt
Sum the numbers in a column with awk
$awk -v c=10 '{s += $c} END {print s}' /var/www/vhosts/system/example.com/logs/access_ssl_log