awktips
 

 awk -F\, 'BEGIN{total=0;} {total += $3;} END{print "total ", total}' /home/avilella/ensembl/slr/all_trees.big.csv
total  1070094

head -n 1000 /home/avilella/ensembl/slr/all_trees.big.csv | awk -F\, '{a[$8]++} END { for (i in a) { print i, a[i] } }' | sort -nk2
type 1
synonymous 67
constant 83
positive 192
default 216
negative 216
random 225

# non-empty files
ls -l | awk '$5 > 0'

# entries between the 1 and 8 of Jan
cat /var/log/*.log | awk '$1 == "Jan" && ($2 >= 1 && $2 <= 8)'

awk -F\, 'BEGIN{total=0;} {total += $3;} END{print "total ", total}' /home/avilella/ensembl/slr/all_trees.big.csv