请教一个shell问题

闸北陆小洪

输入为：

1    "a":"1", "b":"2.3", "c":"1.235"
2    "a":"1.1","c":"1.23d","b":"2.32"
3    "b":"2.33", "c":"1.233","a":"1.2"
4    "b":"2.3f", "a":"1.3", "c":"1.23g"
5    "a":"1.4", "b":"2.3y", "c":"1.23h"


要求的输出为：

1    1,2.3,1.235
2    1.1,2.32,1.23d
3    1.2,2.33,1.233
4    1.3,2.3f,1.23g
5    1.4,2.3y,1.23h

就是把a b c的值拿出来

thx

好人家

sed -r 's/^\"[a-z,^\"]+\":\"([^"].*)\", \"[a-z,^\"]+\":\"([^"].*)\", \"[a-z,^\"]+\":\"([^"].*)\"$/\1,\t\2,\t\3/' urfile

1,      2.3,    1.235
1.1,    2.32,   1.23d
1.2,    2.33,   1.233
1.3,    2.3f,   1.23g
1.4,    2.3y,   1.23h

awk -F[\"] '{print $4","$8","$12}' urfile

L_kernel

1. $ cat file.txt
   
2. 1    "a":"1", "b":"2.3", "c":"1.235"
   
3. 2    "a":"1.1","c":"1.23d","b":"2.32"
   
4. 3    "b":"2.33", "c":"1.233","a":"1.2"
   
5. 4    "b":"2.3f", "a":"1.3", "c":"1.23g"
   
6. 5    "a":"1.4", "b":"2.3y", "c":"1.23h"
   
7. 
   
8. $ sed -e 's/.[abc]...//g;s/^[0-9] \+//;s/[" ]//g' file.txt
   
9. 1,2.3,1.235
   
10. 1.1,1.23d,2.32
    
11. 2.33,1.233,1.2
    
12. 2.3f,1.3,1.23g
    
13. 1.4,2.3y,1.23h
    

复制代码

闸北陆小洪

谢谢各位  非常感谢

ulovko

1. 
   
2. SED:
   
3. > cat out
   
4. 1    "a":"1", "b":"2.3", "c":"1.235"
   
5. 2    "a":"1.1","c":"1.23d","b":"2.32"
   
6. 3    "b":"2.33", "c":"1.233","a":"1.2"
   
7. 4    "b":"2.3f", "a":"1.3", "c":"1.23g"
   
8. 5    "a":"1.4", "b":"2.3y", "c":"1.23h"
   
9. > sed 's/.[abc]...//g;s/[" ]/ /g' out
   
10. 1    1 , 2.3 , 1.235
    
11. 2    1.1 ,1.23d ,2.32
    
12. 3    2.33 , 1.233 ,1.2
    
13. 4    2.3f , 1.3 , 1.23g
    
14. 5    1.4 , 2.3y , 1.23h
    

复制代码

1. 
   
2. AWK:
   
3. > cat out
   
4. 1    "a":"1", "b":"2.3", "c":"1.235"
   
5. 2    "a":"1.1","c":"1.23d","b":"2.32"
   
6. 3    "b":"2.33", "c":"1.233","a":"1.2"
   
7. 4    "b":"2.3f", "a":"1.3", "c":"1.23g"
   
8. 5    "a":"1.4", "b":"2.3y", "c":"1.23h"
   
9. > awk -F'"' '{print NR,$4","$8","$12}' out
   
10. 1 1,2.3,1.235
    
11. 2 1.1,1.23d,2.32
    
12. 3 2.33,1.233,1.2
    
13. 4 2.3f,1.3,1.23g
    
14. 5 1.4,2.3y,1.23h
    

复制代码

winway1988

1. sed -r ':a;s/"[^"]+":"([^"]+)"/\1/;ta' urfile

复制代码

seesea2517

我觉得lz是有顺序要求的，这样的话还是#2的比较符合原意

earwig

L_kernel 发表于 2012-05-24 19:13

正则表达式还是看不懂啊！！！！

L_kernel

earwig 发表于 2012-05-25 11:05
正则表达式还是看不懂啊！！！！

O'Reilley Master Regular Expression 3rd Edition