Process CSV with quotes (gawk)

Parse quoted CSV fields correctly with FPAT in gawk

gawk -v FPAT='([^,]+)|("[^"]+")' '{print $2}' data.csv

More awk commands

BEGIN/END blocks

awk 'BEGIN{print "Start"} {lines++} END{print lines" lines processed"}' file.txt

Run code before and after processing all lines
Two-file join on key

awk 'NR==FNR{a[$1]=$2; next} $1 in a {print $0, a[$1]}' lookup.txt data.txt

Left-join data.txt with lookup.txt on first field
Print specific column

awk '{print $3}' file.txt

Print the 3rd whitespace-delimited field
Custom field separator

awk -F: '{print $1, $3}' /etc/passwd

Use colon as field separator, print user and UID
Filter rows by pattern

awk '/ERROR/ {print NR": "$0}' app.log

Print line number and content for lines matching ERROR