awk 去掉某列最后一个字符 取指定某列方括号里面的内容

skypeleo

2014-11-05 09:39:48: ip[192.168.10.152] logId[281424076]
2014-11-05 09:58:33: ip[192.168.10.152] logId[393876725]
2014-11-05 09:58:33: ip[192.168.10.152] logId[393883438]
2014-11-05 09:58:34: ip[192.168.10.152] logId[394052520]
2014-11-05 09:58:34: ip[192.168.10.152] logId[394057519]

第2列去掉最后一个冒号， 第3列和第4列取方括号里面的内容

先感谢大家

yestreenstars

目测一下先~

1. [root@localhost ~]# sed -r 's/://3;s/\S+\[([^]]+)\]/\1/g' i
   
2. 2014-11-05 09:39:48 192.168.10.152 281424076
   
3. 2014-11-05 09:58:33 192.168.10.152 393876725
   
4. 2014-11-05 09:58:33 192.168.10.152 393883438
   
5. 2014-11-05 09:58:34 192.168.10.152 394052520
   
6. 2014-11-05 09:58:34 192.168.10.152 394057519
   
7. [root@localhost ~]#

复制代码

关阴月飞

1. awk -F '[] []+|: ' '{print $1,$2,$4,$6}'  urfile
   
2. awk '{a=gensub(/:/,"",3,$2);split($3,b,"[][]");split($4,c,"[][]");print $1,a,b[2],c[2]}' urfile
   

复制代码

jason680

回复 1# skypeleo

$ awk 'function v(s, r){r=s;if(match(s,/\[([^]]+)\]/,a))r=a[1];return(r)}{sub(/:$/,"",$2);$3=v($3);$4=v($4)}1' FILE
2014-11-05 09:39:48 192.168.10.152 281424076
2014-11-05 09:58:33 192.168.10.152 393876725
2014-11-05 09:58:33 192.168.10.152 393883438
2014-11-05 09:58:34 192.168.10.152 394052520
2014-11-05 09:58:34 192.168.10.152 394057519

   

skypeleo

  谢谢大家  

tasteoftime_90

1. sed -r 's/: ..\[(.+)\] .+\[(.+)\]/ \1 \2/' file

复制代码

回复 1# skypeleo


   

jcdiy0601

sed

1. sed 's/: / /;s/ip\[\(.*\)\]/\1/;s/\].*\[/ /' test

复制代码

python

1. #!/usr/bin/env python
   
2. 
   
3. import re
   
4. 
   
5. file = open('test')
   
6. done = 0
   
7. while not done:
   
8.         line = file.readline()
   
9.         if line != '':
   
10.                 line = line.strip('\n')
    
11.                 this_line_list = line.split(' ')
    
12.                 zz1 = re.compile('[0-9]{2}:[0-9]{2}:[0-9]{2}')
    
13.                 zz2 = re.compile('[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}')
    
14.                 zz3 = re.compile('[0-9]{1,}')
    
15.                 pp1 = re.findall(zz1,this_line_list[1])
    
16.                 pp2 = re.findall(zz2,this_line_list[2])
    
17.                 pp3 = re.findall(zz3,this_line_list[3])
    
18.                 print '%s %s %s %s' % (this_line_list[0],pp1[0],pp2[0],pp3[0])
    
19.         else:
    
20.                 done = 1
    
21. file.close()

复制代码

zxy877298415

回复 1# skypeleo
awk '{print gensub(/(: ip\[)|(ip\[)|(\] logId\[)|(\])/," ","G")}' FILE


   

reyleon

1. #!/usr/bin/python
   
2. # -*- coding: utf-8 -*-
   
3. 
   
4. import fileinput, sys, re
   
5. for line in fileinput.input(sys.argv[1]):
   
6.     record = re.findall('(\d+-\d+-\d+).*?(\d+:\d+:\d+).*?\[(.*?)\].*?\[(.*?)\]',line)
   
7.     print ' '.join(record[0])

复制代码