Awk Cheatsheet

awk: A versatile programming language for working on files.

Print the fifth column (a.k.a. field) in a space-separated file:

awk '{print $5}' path/to/file

Print the second column of the lines containing “foo” in a space-separated file:

awk '/foo/ {print $2}' path/to/file

Print the last column of each line in a file, using a comma (instead of space) as a field separator:

awk -F ',' '{print $NF}' path/to/file

Sum the values in the first column of a file and print the total:

awk '{s+=$1} END {print s}' path/to/file

Print every third line starting from the first line:

awk 'NR%3==1' path/to/file

Print different values based on conditions:

awk '{if ($1 == "foo") print "Exact match foo"; else if ($1 ~ "bar") print "Partial match bar"; else print "Baz"}' path/to/file

Print all lines where the 10th column value equals the specified value:

awk '($10 == value)'

Print all the lines which the 10th column value is between a min and a max:

awk '($10 >= min_value && $10 <= max_value)'

For more info, check its repo: https://github.com/onetrueawk/awk .

I hope this post helps you. If you know a person who can benefit from this information, send them a link of this post. If you want to get notified about new posts, follow me on YouTube , Twitter (x) , LinkedIn , and GitHub .