trying to get the results using awk

问题:

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?

回答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