I've got it working as expected when looking at 1 column:
cat /tmp/inputfile | awk -F : '$12 !~ /100/ { print $6,$12,$13}'
cat /tmp/inputfile | awk -F : '$12 ~ /100/ { print $6,$12,$13}'
4726753 100 137
But when I try to make the next step in the process (look at 2 columns and print if the pair is not "100 137" it prints under BOTH conditions. Since it simultaneously meets both conditions (does match and does not match), it must be ignoring my conditional right?
cat /tmp/inputfile | awk -F : '$12,$13 ~ /100 137/ { print $6,$12,$13}'
4726753 100 137
cat /tmp/inputfile | awk -F : '$12,$13 !~ /100 137/ { print $6,$12,$13}'
4726753 100 137
Fixing/understanding this is step 1. The finished result should check for "100 137" and "0 0" and only print if $12,$13 are neither of those pairs.
-F :
is used for. 2)awk '$12 != 100 && $13 != 137'
?cat file | awk 'stuff'
; justawk 'stuff' file
.