I have a csv files with say 20 odd columns.
I need to get the 14th and 15th column values where value in 14th column is say
"VALUE1" and value in 15th column is
My condition gets satisfied only when 14th column has
VALUE1 and 15th column has
VALUE2. I need to get the aggregate count.
wc -l could give me the count list and
cut -d "," -f14,15 gives me the 14th and 15th column values. But how to check whether 14th has
VALUE1 and 15th has
UPD: I think the one below works
grep -r "" * | cut -d " " -f14,15 | grep "Value1" | grep "Value2"
but still I dont think this is the perfect way to do do it.