- 论坛徽章:
- 32
|
回复 6# conall
这样子吗?- [root@localhost ~]# awk 'BEGIN{FS=OFS=";"}NR==FNR&&!a[$1,$2,$3,$4,$5]++{b[$5]++;if($7~/^ *$/)c[$5]++;next}{print $0,b[$5],c[$5]}' i i
- BJRNC25;SITE;BJS0860;2012-10-19;2012-10-19 04:23;2012-10-19 04:23:53; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,InternalEthernetPort=1,IpInterface=1;3102;Contact to Default Router 1 Lost;1;1
- BJRNC30;SITE;BJN5584;2013-11-01;2013-11-01 07:23;2013-11-01 07:23:49;2013-11-1 07:23:56;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,InternalEthernetPort=1,IpInterface=1;3102;Contact to Default Router 1 Lost;1;
- BJRNC18;SITE;BJS0978;1970-1-01;1970-1-01 08:03;1970-1-01 08:03:13; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,EthernetSwitch=1,EthernetSwitchPort=6;3151;Ethernet Switch Port Fault;1;1
- BJRNC09;SITE;BJS5780;2012-10-08;2012-10-08 01:31;2012-10-08 01:31:24; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,EthernetSwitch=1,EthernetSwitchPort=6;3151;Ethernet Switch Port Fault;1;1
- BJRNC08;SITE;BJN1050;2012-10-10;2012-10-10 02:03;2012-10-10 02:03:04; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,EthernetSwitch=1,EthernetSwitchPort=6;3151;Ethernet Switch Port Fault;1;1
- BJRNC25;SITE;BJS0860;2012-10-19;2012-10-19 04:23;2012-10-19 04:23:53; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,InternalEthernetPort=1,IpInterface=1;3101;Contact to Default Router 0 Lost;1;1
- BJRNC25;SITE;BJS0860;2012-10-19;2012-10-19 04:23;2012-10-19 04:23:53; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,InternalEthernetPort=1,IpInterface=1;3102;Contact to Default Router 1 Lost;1;1
- BJRNC11;SITE;BJN0585;2012-10-21;2012-10-21 04:53;2012-10-21 04:53:43; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,EthernetSwitch=1,EthernetSwitchPort=6;3151;Ethernet Switch Port Fault;1;1
- BJRNC10;SITE;BJN5890;2012-10-21;2012-10-21 16:02;2012-10-21 16:02:23; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,EthernetSwitch=1,EthernetSwitchPort=6;3151;Ethernet Switch Port Fault;1;1
- BJRNC09;SITE;BJS6220;2012-11-02;2012-11-02 01:09;2012-11-02 01:09:23; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,EthernetSwitch=1,EthernetSwitchPort=6;3151;Ethernet Switch Port Fault;1;1
- BJRNC14;SITE;BJN0768;2012-11-04;2012-11-04 16:29;2012-11-04 16:29:56; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,EthernetSwitch=1,EthernetSwitchPort=6;3151;Ethernet Switch Port Fault;1;1
- BJRNC25;SITE;BJS6156;2012-11-09;2012-11-09 09:40;2012-11-09 09:40:02; ;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,EthernetSwitch=1,EthernetSwitchPort=6;3151;Ethernet Switch Port Fault;1;1
- BJRNC30;SITE;BJN5584;2013-11-01;2013-11-01 07:15;2013-11-01 07:15:24;2013-11-1 07:15:32;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,InternalEthernetPort=1,IpInterface=1;3102;Contact to Default Router 1 Lost;1;
- BJRNC30;SITE;BJN5584;2013-11-01;2013-11-01 07:23;2013-11-01 07:23:49;2013-11-1 07:23:56;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,InternalEthernetPort=1,IpInterface=1;3101;Contact to Default Router 0 Lost;1;
- BJRNC30;SITE;BJN5584;2013-11-01;2013-11-01 07:23;2013-11-01 07:23:49;2013-11-1 07:23:56;Subrack=1,Slot=2,PlugInUnit=1,ExchangeTerminalIp=1,InternalEthernetPort=1,IpInterface=1;3102;Contact to Default Router 1 Lost;1;
- [root@localhost ~]#
复制代码 |
|