处理json中的内容

hope1234567hope

将csv的转换为json后，此时为tst.json文件如下：
[{"a":"10.100.121.187","b":"liux18","c":"2015-11-02 00:00:36","d":"GET /1jsp"},
{"a":"10.100.91.88","b":"liyunguo","c":"2012-01-01 00:01:19","d":"GET /p2.jsp"},
{"a":"10.208.26.203","b":"xuaiping1","c":"2010-12-01 00:01:31","d":"GET /in.jsp"},
{"a":"10.100.91.88","b":"liyunguo","c":"2013-12-31 00:01:32","d":"GET /n.jsp"},
{"a":"10.100.59.3","b":"liushubin2","c":"2014-12-14 00:02:46","d":"GET /2"},
{"a":"10.100.59.3","b":"liushubin2","c":"2011-12-12 00:11:46","d":"GET /1"}]

想将文件中所有的c中的内容改为类似如下的（此举例第一行的）
"c":"2015-11-02 00:00:36"  改为 "c" : {"$date" : "2015-11-02T00:00:36Z"}
请问这个shell怎么写？

elu_ligao

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

复制代码

moperyblue

1. sed -r '/"c"/s/(.*"c":)(\S+)\s([^"]*)"/\1 {"$date" : \2T\3Z"}/'

复制代码

reb00t

1. n [7]: d = {"a":"10.100.121.187","b":"liux18","c":"2015-11-02 00:00:36","d":"GET /1jsp"}
   
2. 
   
3. In [8]: d
   
4. Out[8]:
   
5. {'a': '10.100.121.187',
   
6. 'b': 'liux18',
   
7. 'c': '2015-11-02 00:00:36',
   
8. 'd': 'GET /1jsp'}
   
9. 
   
10. In [17]: d['c']= "%sT%sZ" % tuple(d['c'].split())
    
11. 
    
12. In [18]: d['c']
    
13. Out[18]: '2015-11-02T00:00:36Z'
    
14. 
    
15. In [19]: d['c']={'$date':d['c']}
    
16. 
    
17. In [20]: d
    
18. Out[20]:
    
19. {'a': '10.100.121.187',
    
20. 'b': 'liux18',
    
21. 'c': {'$date': '2015-11-02T00:00:36Z'},
    
22. 'd': 'GET /1jsp'}

复制代码

python的代码本身就能实现，python里面在加shell看起来不伦不类

hope1234567hope

正打算学习python，能写一个Python的脚本么？我学习下，谢谢！回复 4# reb00t

jason680

回复 1# hope1234567hope

1. $ perl -pe '{s/("c":)"([^"]+)"/$1\{"\$date":"$2Z"\}/g}' tst.json
   
2. [{"a":"10.100.121.187","b":"liux18","c":{"$date":"2015-11-02 00:00:36Z"},"d":"GET /1jsp"},
   
3. {"a":"10.100.91.88","b":"liyunguo","c":{"$date":"2012-01-01 00:01:19Z"},"d":"GET /p2.jsp"},
   
4. {"a":"10.208.26.203","b":"xuaiping1","c":{"$date":"2010-12-01 00:01:31Z"},"d":"GET /in.jsp"},
   
5. {"a":"10.100.91.88","b":"liyunguo","c":{"$date":"2013-12-31 00:01:32Z"},"d":"GET /n.jsp"},
   
6. {"a":"10.100.59.3","b":"liushubin2","c":{"$date":"2014-12-14 00:02:46Z"},"d":"GET /2"},
   
7. {"a":"10.100.59.3","b":"liushubin2","c":{"$date":"2011-12-12 00:11:46Z"},"d":"GET /1"}]

复制代码

hope1234567hope

发觉不行，主要是"c": "2015-11-02 00:00:36"的 "2015(也就是与：之间有个空格)前面有个空格，这样此语句就起作用了，该怎么改sed呢？对sed确实不是很明白，谢谢回复 2# elu_ligao

elu_ligao

那就加个空格呀

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

复制代码

hope1234567hope

谢谢。能解释下\("[^ ]\+\) \([^"]\+\)"/\1{"$date":\2T\3Z"}的意思么 ，谢谢了  ，确实对这个不是明白，见笑了
主要是\ 和 ）回复 8# elu_ligao

expert1

建议你了解下jq,这个才是处理json的标准。