log日志初始文件内容如下:'
"2017-04-26 09:23:04","ac:c1:ee:3c:f9:63","http://www.wangfanwifi.com:16621/api/pageTime?uid=&hitID=bootstrap&browserID=2Cxz4MWqDSJDHJ5RliLg7QtfIpaxkt4h","192.168.10.29","1","2","未知","chrome","3000fa","手工上线[3000fa]"
"2017-04-26 09:23:04","d8:1d:72:7b:f5:68","http://www.wangfanwifi.com:16621/api/pageTime?uid=&hitID=bootstrap&browserID=c6EnFEB1pMN1CrbAYgjYQK8r3Lkdaufi","192.168.10.183","3","2","iPhone","Safari","3000fa","手工上线[3000fa]"
"2017-04-27 19:30:16","18:59:36:17:bd:e7","http://www.wangfanwifi.com:16621/api/pageTime?uid=&hitID=bootstrap&browserID=koTps7bV3WZnhp1xAzXtxUhVsNqIsYXZ","192.168.10.62","1","2","未知","chrome","703d6d","鲁FJ27035"
"2017-04-27 19:32:20","18:59:36:17:bd:e7","http://www.wangfanwifi.com:16621/api/pageTime?uid=&hitID=bootstrap&browserID=koTps7bV3WZnhp1xAzXtxUhVsNqIsYXZ","192.168.10.62","1","2","未知","chrome","703d6d","鲁FJ27035"
"2017-04-24 11:27:04","fc:64:ba:ef:51:44","http://www.wangfanwifi.com:16621/api/pageTime?uid=&hitID=bootstrap&browserID=mGoclWIMCvbGwaJm4GZJRq6ltQd4yuAM","192.168.10.84","1","2","未知","chrome","705de1","手工上线[705de1]"
"2017-04-24 11:27:04","fc:64:ba:ef:51:44","http://www.wangfanwifi.com:16621/api/pageTime?uid=&hitID=bootstrap&browserID=mGoclWIMCvbGwaJm4GZJRq6ltQd4yuAM","192.168.10.84","1","2","未知","chrome","705de1","手工上线[705de1]"
"2017-04-24 11:27:05","fc:64:ba:ef:51:44","http://www.wangfanwifi.com:16621/api/pageTime?uid=&hitID=bootstrap&browserID=mGoclWIMCvbGwaJm4GZJRq6ltQd4yuAM","192.168.10.84","1","2","未知","chrome","705de1","手工上线[705de1]"
我需要统计除第一列以外的每一行的后面部分作为group by的字段,并且计算出group by之后每组的条数:
cat aio.log-2017-04-19-23.log|grep 'api/pageTime' |awk -F "," '{for(i=2;i<=NF;i++) printf("%s,",$i); print("")}' |awk '{a[$0]+=1}END{for(i in a) {printf "%s %d\n",substr(i,0,16),a[i]}}'
留作备忘