Jun 12, 2009

Counting Matching Records using AWK


Syntax :

awk -F\| '{if($
`COLUMN-NO` == `MATCH-STRING`) {print $3; } }' < `IN-FILE.txt`|awk '{sum = sum + $1} END {print sum;}'

awk -F\| '{if($
4 == 4177380) {print $3; } }' < input.txt|awk '{sum = sum + $1} END {print sum;}'