trying to get the results using awk

Question

I've a file named xyz.csv which are comma separated.I'm trying to get the output where the 2nd column should have value "01", 50th column as "ABC" and the content of 80th column using nawk?

Answer 1

Could you please try following and let me know if this helps.

nawk -F"," '$2=="01" && $50 == "ABC"{print $80}'  xyz.csv

OR

If you are looking for 50th and 80th field's value should be ABC and you want to print current line then following may help you in same.

nawk -F"," '$2=="01" && $50 == "ABC" && $80 == "ABC"'  xyz.csv