处理json中的内容

jcdiy0601

1. #!/usr/bin/env python
   
2. #_*_ coding:utf-8 _*_
   
3. 
   
4. import json
   
5. 
   
6. f = open('tst','r')
   
7. old_L = json.loads(f.read())
   
8. new_L = []
   
9. for line in old_L:
   
10.     l = line['c'].split()
    
11.     line['c'] = {"$data": "%sT%sZ" % (l[0],l[1])}
    
12.     new_L.append(line)
    
13. 
    
14. f = open('new_tst.json','w')
    
15. json.dump(new_L,f)

复制代码

elu_ligao

回复 9# hope1234567hope


[{"a":"10.100.121.187","b":"liux18","c":"2015-11-02 00:00:36","d":"GET /1jsp"},

\("c":\)\("[^ ]\+\) \([^"]\+\)"/\1{"$date":\2T\3Z"}

sunzhiguolu

1. perl -pe 'BEGIN{$r=qr/(\d+(?:[:-]\d+)+)/}{s/"$r\h$r"/{"\$date":"${1}T${2}Z"}/}' f

复制代码

[{"a":"10.100.121.187","b":"liux18","c":{"$date":"2015-11-02T00:00:36Z"},"d":"GET /1jsp"},
{"a":"10.100.91.88","b":"liyunguo","c":{"$date":"2012-01-01T00:01:19Z"},"d":"GET /p2.jsp"},
{"a":"10.208.26.203","b":"xuaiping1","c":{"$date":"2010-12-01T00:01:31Z"},"d":"GET /in.jsp"},
{"a":"10.100.91.88","b":"liyunguo","c":{"$date":"2013-12-31T00:01:32Z"},"d":"GET /n.jsp"},
{"a":"10.100.59.3","b":"liushubin2","c":{"$date":"2014-12-14T00:02:46Z"},"d":"GET /2"},
{"a":"10.100.59.3","b":"liushubin2","c":{"$date":"2011-12-12T00:11:46Z"},"d":"GET /1"}]

hope1234567hope

回复 11# jcdiy0601

能都跟你请教下，但是权限太低，都无法跟你发消息，我可以给我发个你的消息么？

sunzhiguolu

1. perl -pe 's/(?="\d+-)(.+?)"/{"\$date",$1Z"}/' f

复制代码