unix内可以做到像excel般的统计吗?

yinyuemi

1. 1. awk -F"'" '/event/{a[$2"\t"substr($3,5)]=++b[$3]}END{for(i in a) print i"\t"a[i]|"sort -n "}' file
   
2. 
   
3. 2. awk -F "'| " 'BEGIN{print "lequipmentlocation: USA"}
   
4. /event/ {a["event code: "$NF]>0?a["event code: "$NF]="\n"$1"\t"$(NF-4):a["event code: "$NF]=a["event code: "$NF]"\n" $1"\t"$(NF-4)}
   
5. END{for (i in a) print i, a[i]"\n"}' file

复制代码

yinyuemi

回复 16# xmi

第二个结果是这个么？

1. 1. awk -F"'" 'BEGIN{"header1","header2","header3","header4"}/event/{a[$2"\t"substr($3,5)]=++b[$3]}END{for(i in a) print i"\t"a[i]|"sort -n "}'
   
2. 
   
3. 2. awk -F "'| " 'BEGIN{print "lequipmentlocation: USA"} /event/ {a["event code: "$NF]>0?a["event code: "$NF]="\n"$1"\t"$(NF-4):a["event code: "$NF]=a["event code: "$NF]"\n" $1"\t"$(NF-4)}END{for (i in a) print i, a[i]"\n"}' file
   
4. 
   
5. event code: 77
   
6. 09Feb11-13:55:54:283    USAP07
   
7. 
   
8. event code: 9
   
9. 09Feb11-13:59:59:982    USAP07
   
10. 
    
11. event code: 12
    
12. 09Feb11-13:45:00:108    USAE01
    
13. 
    
14. event code: 22
    
15. 09Feb11-13:56:56:133    USAP07
    
16. 
    
17. event code: 23
    
18. 09Feb11-14:00:01:245    USAP02
    
19. 09Feb11-14:00:01:253    USAP03
    
20. 09Feb11-14:00:01:254    USAE01
    
21. 09Feb11-14:00:01:255    USAP02
    
22. 09Feb11-14:00:01:258    USAP03
    
23. 09Feb11-14:00:01:260    USAP05
    
24. 
    
25. event code: 33
    
26. 09Feb11-13:45:00:716    USAA01
    
27. 
    
28. event code: 440
    
29. 09Feb11-14:00:00:035    USAP06
    
30. 09Feb11-14:00:00:050    USAE06
    
31. 09Feb11-14:00:00:051    USAP03
    
32. 09Feb11-14:00:00:072    USAP03
    
33. 09Feb11-14:00:00:075    USAP02
    
34. 09Feb11-14:00:00:081    USAP05
    
35. 
    
36. event code: 1
    
37. 09Feb11-14:00:00:016    USAP05
    
38. 
    
39. event code: 44
    
40. 09Feb11-13:45:00:151    USAP02
    
41. 
    
42. event code: 2
    
43. 09Feb11-13:59:59:998    USAP01
    
44. 
    
45. event code: 55
    
46. 09Feb11-13:50:40:303    USAA05
    
47. 
    
48. event code: 156
    
49. 09Feb11-13:55:48:228    USAP02
    
50. 
    
51. event code: 66
    
52. 09Feb11-13:56:52:380    USAP07
    
53. 
    

复制代码

yinyuemi

回复 18# xmi


   开始改下呢,加个转义：
awk -F "\'| "

yinyuemi

回复 24# xmi


    要不你把代码存成文件script.awk
然后执行 awk -f script.awk urfile
希望这样可以

yinyuemi

回复 27# xmi


    改下前面的部分：

1. awk  'BEGIN{FS="|";print "lequipmentlocation: USA"}

复制代码