文件清洗，大神帮帮忙！

hongjie7456

文件类似这样
clientid=1009&metric=Economy&userid=oZrAXv8ILUA5303s0jk7LU4q3CeU&currency=3&kingdom=expenditure

想通过python 正则进行匹配 ，把相关字段的值进行重组  。

输出结果为

metric 的值\t userid的值\t clientid的值\t currency 的值\t kingdom 的值

Economy      oZrAXv8ILUA5303s0jk7LU4q3CeU       1009    3   expenditure

那个大神帮忙指教一下。

haooooaaa

回复 1# hongjie7456

1. import re
   
2. a="clientid=1009&metric=Economy&userid=oZrAXv8ILUA5303s0jk7LU4q3CeU&currency=3&kingdom=expenditure"
   
3. print re.search(r'clientid=([^&]*)&metric=([^&]*)&userid=([^&]*)&currency=([^&]*)&kingdom=([^&]*)', a).groups()
   
4. 
   
5. $ python s.py
   
6. ('1009', 'Economy', 'oZrAXv8ILUA5303s0jk7LU4q3CeU', '3', 'expenditure')

复制代码

zsszss0000

1. echo "clientid=1009&metric=Economy&userid=oZrAXv8ILUA5303s0jk7LU4q3CeU&currency=3&kingdom=expenditure" | awk -vFS="[=&]" '{printf $4 "\t" $6 "\t" $2 "\t" $8 "\t" $10 "\n"}'

复制代码

1. Economy oZrAXv8ILUA5303s0jk7LU4q3CeU    1009    3       expenditure

复制代码

substr函数

1. #!/usr/bin/python2
   
2. # coding: utf-8
   
3. 
   
4. line = 'clientid=1009&metric=Economy&userid=oZrAXv8ILUA5303s0jk7LU4q3CeU&currency=3&kingdom=expenditure'
   
5. 
   
6. 
   
7. # 相关字段 有序
   
8. 
   
9. order = (1, 2, 0, 3, 4)
   
10. field = [i.split('=')[1] for i in line.split('&')]
    
11. print "\t".join(field[i] for i in order)
    
12. 
    
13. # 相关字段  无序
    
14. 
    
15. order = ('metric', 'userid', 'clientid', 'currency', 'kingdom')
    
16. field = dict(i.split('=') for i in line.split('&'))
    
17. print "\t".join(field[i] for i in order)
    
18. 
    
19. # 其实还有其他的方式。总而言之，就是TMTOWTDI。
    

复制代码