Search Results

Define an awk variable using shell variable:-
color="Blue"

awk -F, -v COL="$color" '$2 == COL && $3 == "Yes" {c++} END{print c}' myfile.csv

awk -F, '$2 ~ /Blue/ && $3 == "Yes" {c++} END {print c}' myfile.csv