关于AWK 的处理文件内容

ywlscpl

回复 6# cczn

1. ywlscpl@ubuntu:~$ awk -F, '/@/{a[$1","$2]=$3"-"a[$1","$2]}END{for (i in a) {split(a[i],m,"-");print i","m[1]-m[2](m[2]?"":" ok")}}' file   
   
2. 144999,test2@test2.com,100 ok
   
3. 144888,test1@test1.com,500 ok
   
4. 123456,abc@test.com,100
   
5. 999999,zzz@163.com,300 ok
   
6. 444444,ppp@pppp.com,100 ok
   
7. 111111,hhh@163.com,100
   
8. 555555,ooo@oooo.com,100 ok

复制代码