help~ 数据统计shell

expert1

没看出规律

jerryswxs

07/14/10 15:46:21 :     CALLIN in ch 1: Caller = 13888888888, Called = 88888113877777777
07/14/10 15:46:21 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
07/14/10 15:46:21 : makeDialRouter return RESULT_OK
07/14/10 15:46:21 :     BEGINNING CALLOUT : Caller = 8888812345678, Called = 13877777777
07/14/10 15:46:21 : SsmPickup(3
07/14/10 15:46:21 : Auto dial out : ch = 38
07/14/10 15:46:25 : Ringing ...
07/14/10 15:46:25 : Backward call indicators: 1214
07/14/10 15:46:46 : Hangup channel 1
07/14/10 15:46:46 : Hangup channel 38
07/14/10 15:47:04 :     CALLIN in ch 56: Caller = 13888888888, Called = 88888113877777777
07/14/10 15:47:04 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
07/14/10 15:47:04 : makeDialRouter return RESULT_OK
07/14/10 15:47:04 :     BEGINNING CALLOUT : Caller = 8888812345678, Called = 13877777777
07/14/10 15:47:04 : SsmPickup(45)
07/14/10 15:47:04 : Auto dial out : ch = 45
07/14/10 15:47:05 :     CALLIN in ch 52: Caller = 13888888888, Called = 88888113877777777
07/14/10 15:47:05 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
07/14/10 15:47:05 : makeDialRouter return RESULT_OK
07/14/10 15:47:05 :     BEGINNING CALLOUT : Caller = 8888812345678 Called =
13877777777
07/14/10 15:47:05 : SsmPickup(47)
07/14/10 15:47:05 : Auto dial out : ch = 47
07/14/10 15:47:08 : Ringing ...
07/14/10 15:47:08 : Backward call indicators: 1214
07/14/10 15:47:09 : Ringing ...
07/14/10 15:47:09 : Backward call indicators: 1214
07/14/10 15:47:09 : INFO: getRingBackTone ringBackId = -1
07/14/10 15:47:09 : ERROR: set ringBackId = 1(default)
07/14/10 15:47:09 :     PLAY 4401: in channel 52
07/14/10 15:47:18 : Hangup channel 56
07/14/10 15:47:18 : Hangup channel 45
07/14/10 19:26:26 :     CALLIN in ch 5: Caller = 13888888888, Called = 88888113877777777
07/14/10 19:26:26 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
07/14/10 19:26:26 : makeDialRouter return RESULT_IVR
07/14/10 19:26:26 : SsmPickup(5)
07/14/10 19:26:26 :     PLAY 4328: in channel 5
07/14/10 19:26:45 : 7
07/14/10 19:26:45 :     PLAY 4045: in channel 5
07/14/10 19:27:01 :     PLAY 4045: in channel 5
07/14/10 19:27:01 : Hangup channel 5
07/14/10 19:27:14 :     CALLIN in ch 39: Caller = 13888888888, Called = 88888113877777777
07/14/10 19:27:14 : INFO: dialInCaller--> 13888888888, dialInCalled--> 88888113877777777
07/14/10 19:27:14 : makeDialRouter return RESULT_IVR
07/14/10 19:27:14 : SsmPickup(39)
07/14/10 19:27:14 :     PLAY 4328: in channel 39
07/14/10 19:27:19 : 1
07/14/10 19:27:19 :     PLAY 4045: in channel 39
07/14/10 19:27:33 : 1
07/14/10 19:27:33 :     PLAY 4015: in channel 39
07/14/10 19:27:46 : Hangup channel 39


   竟然还有些有INFO: dialInCaller，没BEGINNING CALLOUT的行，各位大哥有啥好办法吗?

kwokcn

怎么分隔符最后还有不一样的，第三段的逗号没了……
单纯按你给的数据：

1. 
   
2. grep -Po '[0-9]{11,}' URFILE | xargs -n 6 | awk '{print $3,$4,"---- >>",$5,$6}'
   

复制代码

kwokcn

刚发完又换了……

1. 
   
2. awk -F'[, \t]+' '/CALLIN/{s=$10" "$13}/CALLOUT/{print s" ---- >> "$9,$12}' URFILE
   

复制代码

expert1

grep -Po '[0-9]{11,}' URFILE | xargs -n 6 | awk '{print $3,$4,"---- >>",$5,$6}'

这个思路很好，呵呵，没仔细想这些，学习了。

jerryswxs

awk -F'[, \t]+' '/CALLIN/{s=$10" "$13}/CALLOUT/{print s" ---- >> "$9,$12}' URFILE

这样写那些有INFO: dialInCaller,没有BEGINNING CALLOUT的行第二字段打印的是空值吗？

expert1

PS：应该是-Eo更好吧

kwokcn

遇到CALLIN就储存，遇到CALLOUT才输出。

jerryswxs

iamgod12345678

回复 5# ywlscpl


    求解释，怎么两行数据合并的？？？