help~ 数据统计shell

mgqw

回复 8# bbgg1983


    你的头像也不错{:3_203:}

mgqw

回复 1# jerryswxs

1. 07/14/10 15:46:21 :     CALLIN in ch 1: Caller = 13888888888, Called = 88888113877777777
   
2. 07/14/10 15:46:21 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
   
3. 07/14/10 15:46:21 : makeDialRouter return RESULT_OK
   
4. 07/14/10 15:46:21 :     BEGINNING CALLOUT : Caller = 8888812345678, Called = 13877777777
   
5. 07/14/10 15:46:21 : SsmPickup(38)
   
6. 07/14/10 15:46:21 : Auto dial out : ch = 38
   
7. 07/14/10 15:46:25 : Ringing ...
   
8. 07/14/10 15:46:25 : Backward call indicators: 1214
   
9. 07/14/10 15:46:46 : Hangup channel 1
   
10. 07/14/10 15:46:46 : Hangup channel 38
    
11. 07/14/10 15:47:04 :     CALLIN in ch 56: Caller = 13888888888, Called = 88888113877777777
    
12. 07/14/10 15:47:04 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
    
13. 07/14/10 15:47:04 : makeDialRouter return RESULT_OK
    
14. 07/14/10 15:47:04 :     BEGINNING CALLOUT : Caller = 8888812345678, Called = 13877777777
    
15. 07/14/10 15:47:04 : SsmPickup(45)
    
16. 07/14/10 15:47:04 : Auto dial out : ch = 45
    
17. 07/14/10 15:47:05 :     CALLIN in ch 52: Caller = 13888888888, Called = 88888113877777777
    
18. 07/14/10 15:47:05 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
    
19. 07/14/10 15:47:05 : makeDialRouter return RESULT_OK
    
20. 07/14/10 15:47:05 :     BEGINNING CALLOUT : Caller = 8888812345678 Called =
    
21. 13877777777
    
22. 07/14/10 15:47:05 : SsmPickup(47)
    
23. 07/14/10 15:47:05 : Auto dial out : ch = 47
    
24. 07/14/10 15:47:08 : Ringing ...
    
25. 07/14/10 15:47:08 : Backward call indicators: 1214
    
26. 07/14/10 15:47:09 : Ringing ...
    
27. 07/14/10 15:47:09 : Backward call indicators: 1214
    
28. 07/14/10 15:47:09 : INFO: getRingBackTone ringBackId = -1
    
29. 07/14/10 15:47:09 : ERROR: set ringBackId = 1(default)
    
30. 07/14/10 15:47:09 :     PLAY 4401: in channel 52
    
31. 07/14/10 15:47:18 : Hangup channel 56
    
32. 07/14/10 15:47:18 : Hangup channel 45
    
33. 07/14/10 19:26:26 :     CALLIN in ch 5: Caller = 13888888888, Called = 88888113877777777
    
34. 07/14/10 19:26:26 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
    
35. 07/14/10 19:26:26 : makeDialRouter return RESULT_IVR
    
36. 07/14/10 19:26:26 : SsmPickup(5)
    
37. 07/14/10 19:26:26 :     PLAY 4328: in channel 5
    
38. 07/14/10 19:26:45 : 7
    
39. 07/14/10 19:26:45 :     PLAY 4045: in channel 5
    
40. 07/14/10 19:27:01 :     PLAY 4045: in channel 5
    
41. 07/14/10 19:27:01 : Hangup channel 5
    
42. 07/14/10 19:27:14 :     CALLIN in ch 39: Caller = 13888888888, Called = 88888113877777777
    
43. 07/14/10 19:27:14 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
    
44. 07/14/10 19:27:14 : makeDialRouter return RESULT_IVR
    
45. 07/14/10 19:27:14 : SsmPickup(39)
    
46. 07/14/10 19:27:14 :     PLAY 4328: in channel 39
    
47. 07/14/10 19:27:19 : 1
    
48. 07/14/10 19:27:19 :     PLAY 4045: in channel 39
    
49. 07/14/10 19:27:33 : 1
    
50. 07/14/10 19:27:33 :     PLAY 4015: in channel 39
    
51. 07/14/10 19:27:46 : Hangup channel 39
    

复制代码

楼主的这个日志文件真是相当的奇葩, 规律完全是乱七八糟的.
    按照楼主的意思猜想了规则:
必须像下面那样, 有INFO: dialInCaller开始, 并且BEGINNING CALLOUT : 结束才会有输出

1. 07/14/10 17:17:59 : INFO: dialInCaller--> 123456789, dialInCalled--> 88888111111111
   
2. 中间随便啥数据
   
3. 07/14/10 17:17:59 :  BEGINNING CALLOUT : Caller =88888987654321, Called = 111111111

复制代码

而且像第18~20行那样, BEGINNING CALLOUT这一行不但最后没有号码, 而且在Called前面的逗号也没有这样的不规则行也不输出

1. 07/14/10 15:47:05 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
   
2. 07/14/10 15:47:05 : makeDialRouter return RESULT_OK
   
3. 07/14/10 15:47:05 :     BEGINNING CALLOUT : Caller = 8888812345678 Called =

复制代码

最终代码:

1. 
   
2. 这个是采用的第一楼楼主数据
   
3. [mgqw@localhost 9999]$ awk -F"[=,>]+" '{ if($0~/INFO: dialInCaller/){a=$2;b=$4}; if($0~/BEGINNING CALLOUT :/&&NF==4){printf("%s %s--->>   %s   %s\n", a, $2, b, $4 ) } }' 6
   
4. 123456789 88888987654321--->>    88888111111111    111111111
   
5. 
   
6. 
   
7. 这个是采用的很长的数据
   
8. [mgqw@localhost 9999]$ awk -F"[=,>]+" '{ if($0~/INFO: dialInCaller/){a=$2;b=$4}; if($0~/BEGINNING CALLOUT :/&&NF==4){printf("%s %s--->>   %s   %s\n", a, $2, b, $4 ) } }' 5
   
9. 13888888888  8888812345678--->>    88888113877777777    13877777777
   
10. 13888888888  8888812345678--->>    88888113877777777    13877777777
    

复制代码

expert1

edisonzfy

#awk -F'(-->)|,|=| |\t' '/INFO: dialInCaller-->/{caller=$7;called=$NF};/BEGINNING CALLOUT/{print caller,$14" --->> "called,$NF}' test.txt  
13888888888 8888812345678 --->> 88888113877777777 13877777777
13888888887 8888812345675 --->> 88888113877777777 13877777777
13888888886 8888812345676 --->> 88888113877777777 13877777777

yuloveban

#!/bin/bash

a=`grep -e "dialInCaller" | grep -v grep | awk -F "--->" '{print $1}' | awk -F "," '{print "$2\t"}'`
b=`grep -e "Caller" | grep -v grep | awk -F "=" '{print $2}' | awk -F "," '{print "$1\t"}'`
c=`grep -e "dialInCalled" | grep -v grep | awk -F "--->" '{print $3}'`
d=`grep -e "Called" | grep -v grep | awk -F "=" '{print $3}'`

echo "$a  $b ---->> $c $d"

exit 0

jerryswxs

谢谢大家

jerryswxs

回复 22# mgqw


    大哥，多谢了~