extract des visites google depuis les logs apache et le transforme en csv

apacheloggoogle2csv

awk '{if($14 ~ /Googlebot/) {print $7}}' apache.log | sort | uniq -c | sort -n | tail -40  | sed 's/^[ \t]*//;s/[ \t]*$//' > top40google.csv
more apache.log | grep Googlebot | awk {'split($4, a, ":");  split(a[1], a, "["); print a[2]'} | sort | uniq -c | sed 's/^[ \t]*//;s/[ \t]*$//' > google-visits-per_day.csv
more apache.log | grep Googlebot | awk {'print $7'} | sort | uniq -c | wc -l