- 论坛徽章:
- 32
|
本帖最后由 yestreenstars 于 2013-11-13 22:17 编辑
基于空行版修改:- [root@localhost ~]# cat i
- 5911043230400514 1 2013-11-08 10:20:41
- 5911043230400531 20 2013-11-09 12:16:07
- 5911043230400595 10 2013-11-09 12:23:16
- 5911043230400595 30 2013-11-09 12:43:16
- 5911043230400564 5 2013-11-09 13:17:47
- 5911043230400528 10 2013-11-09 13:32:46
- 5911043230400595 30 2013-11-09 13:43:16
- 5911043230402162 10 2013-11-09 14:00:59
- 5911043230400531 20 2013-11-10 12:16:07
- 5911043230400595 10 2013-11-10 12:23:16
- 5911043230400595 30 2013-11-10 12:43:16
- 5911043230400564 5 2013-11-10 13:17:47
- 5911043230400528 10 2013-11-10 13:32:46
- 5911043230400595 30 2013-11-10 13:43:16
- [root@localhost ~]# awk '{sub(/:.*/,"",$4)}t&&t!=$3" "$4{print t,s,n;s=n=0}{if(!a[$1,$3]++)++n;s+=$2;t=$3" "$4}END{print t,s,n}' i
- 2013-11-08 10 1 1
- 2013-11-09 12 60 2
- 2013-11-09 13 45 2
- 2013-11-09 14 10 1
- 2013-11-10 12 60 2
- 2013-11-10 13 45 2
- [root@localhost ~]#
复制代码 |
|