文本如何格式化输出？

moshangxie

各位达人，有个文本需要格式化处理，处理的文本如下：

[{"sRemark":"OK","acct_Session_Id":"23514871ppp049dc4041521bca1ebd3","checkmodle":"DB","sNetNo":"dydy0061481","create_time":"2016-07-05 00:00:17","sNASIP":"10.253.80.3","sCallInMAC":"c4:04:15:21:bc:a1"}]
[{"sRemark":"OK","acct_Session_Id":"23545269ppp14758825930cd879ae4a","checkmodle":"DB","sNetNo":"dyhk0000701","create_time":"2016-07
-05 00:00:20","sNASIP":"10.253.80.11","sCallInMAC":"88:25:93:0c:d8:79"}]
[{"sRemark":"OK","acct_Session_Id":"23515372ppp207f44975a5a5653ebd5","checkmodle":"DB","sNetNo":"dydy0020301","create_time":"2016-07
-05 00:00:22","sNASIP":"10.253.80.3","sCallInMAC":"44:97:5a:5a:56:53"}]

这是三行数据，如何处理成如下结果：

23514871ppp049dc4041521bca1ebd3  dydy0061481 2016-07-05 00:00:17  10.253.80.3  c4:04:15:21:bc:a1
23545269ppp14758825930cd879ae4a  dyhk0000701  2016-07-05 00:00:20 10.253.80.11 88:25:93:0c:d8:79
23515372ppp207f44975a5a5653ebd5   dydy0020301 2016-07-05 00:00:22  10.253.80.3   44:97:5a:5a:56:53

谢谢

reyleon

1. #!/usr/bin/python
   
2. # coding:utf8
   
3. 
   
4. import json
   
5. 
   
6. with open('file') as fd:
   
7.     for line in fd:
   
8.         jr = json.loads(line)[0]
   
9.         print '%s %s %s %s %s' %(jr['acct_Session_Id'], jr['sNetNo'], jr['create_time'], jr['sNASIP'], jr['sCallInMAC'])
   

复制代码

moperyblue

1. grep -oP '(acct_Session_Id|sNetNo|create_time|sNASIP|sCallInMAC)...\K[^"]*' file|pr -atJ5
   
2. grep -oP '(acct_Session_Id|sNetNo|create_time|sNASIP|sCallInMAC)...\K[^"]*' file|sed -r ':a;N;/\n(\w+:){5}/!ba;s/\n/\t/g'

复制代码

jason680

回复 1# moshangxie

$ awk -F, 'function g(s){sub(".+\":\"","",s);sub("\"","",s);return(s)}{gsub(/[]{}[]/,"");print g($2),g($4),g($5),g($6),g($7)}' FILE
23514871ppp049dc4041521bca1ebd3 dydy0061481 2016-07-05 00:00:17 10.253.80.3 c4:04:15:21:bc:a1
23545269ppp14758825930cd879ae4a dyhk0000701 2016-07-05 00:00:20 10.253.80.11 88:25:93:0c:d8:79
23515372ppp207f44975a5a5653ebd5 dydy0020301 2016-07-05 00:00:22 10.253.80.3 44:97:5a:5a:56:53

   

moshangxie

都是牛人lol

sunzhiguolu

1. perl -nle 'BEGIN{$/="]\n"}{y/\n//d;print "@a[3,9,11,-1]" if(@a=/"([^"]+)"/g)}' f

复制代码

23514871ppp049dc4041521bca1ebd3 2016-07-05 00:00:17 10.253.80.3 c4:04:15:21:bc:a1
23545269ppp14758825930cd879ae4a 2016-07-05 00:00:20 10.253.80.11 88:25:93:0c:d8:79
23515372ppp207f44975a5a5653ebd5 2016-07-05 00:00:22 10.253.80.3 44:97:5a:5a:56:53

疯子影子

awk -F "," '{split($2,a,":");split($4,b,":");split($5,e,":");split($6,c,":");gsub(/"sCallInMAC":/,"",$7);gsub(/}]/,"",$7); print a[2],b[2],c[2],$7}' c.txt