sed命令_求助

xuzhou2015

1. 直接上文件
--------------------file1--------------------
2015-02-03 21:23:07 {"appTeamName":"方正北斗B型设备","callNo":"309790","deviceType":"1",
"gpsId":"13395595019","y":31.86403,"receiveFlag":"0","speed":83.0,"x":117.29631,"id":0}

2015-02-03 21:23:17 {"gpsId":"13395595019","y":31.86373,"insertDate":"2015-02-03 21:23:17",
"insertUser":"test","speed":84.0,"updateTime":"2015-02-03 21:23:19","x":117.29751,"id":0}

.....


2. file1 文件中的每一行, 都 含有 (x,y)的值.
现在想  提取 每一行的 信息  "x":222, "y":3434
命令如下:
cat car | sed -r 's/.*("y":.*[^,],).*("x":.*[^,],).*/\1\2/'


3. 结果不对?
$ cat car | sed -r 's/.*("y":.*[^,],).*("x":.*[^,],).*/\1\2/'
"y":31.86403,"insertDate":"2015-02-03 21:23:07","insertUser":"test","onlineStatus":"1","receiveFlag":"0","speed":83.0,"updateTime":"2015-02-03 21:23:09","x":117.29631,


请 高手指教

reyleon

1. sed -r 's/.*("y":[^,]*).*("x":[^,]*).*/\1\2/'

复制代码

ly5066113

回复 1# xuzhou2015

1. sed 's/.*\("y":[^,]*\).*\("x":[^,]*\).*/\1 \2/' file

复制代码

goofool

楼主你把电话号码暴露了

zsszss0000

1. sed  -n 's/.*\("y":[0-9]*.[0-9]*\).*\("x":[0-9]*.[0-9]*\).*/\1 \2/p' file

复制代码

TIM写的坐标匹配为

1. \("y":[^,]*\)

复制代码

这个我不太理解，所以就把写成了

1. \("y":[0-9]*.[0-9]*\)

复制代码

zsszss0000

1. sed 's/.*\("y":[^,]*\).*\("x":[^,]*\).*/\1 \2/' file

复制代码

我如果写为

1. sed 's/.*\("y":.*,\).*\("x":.*,\).*/\1----\2/' file

复制代码

得不到正确的结果，得到的结果是

"y":31.86403,"receiveFlag":"0","speed":83.0, ----"x":117.29631,

是不是因为这里采用了贪心的算法，即可以匹配到x前面的逗号，
如果想匹配遇到的第一个，（也就是紧相邻的，）该怎么写？请指导我这个新手。

回复 3# ly5066113


   

ly5066113

回复 6# zsszss0000


正则表达式是贪婪的。

sed 里如果想要匹配第一个“,” ，只能用 [^,]*, 的写法
perl 里支持非贪婪匹配，用 .*? 就可以：

1. perl -pe 's/.*("y":.*?),.*("x":.*?),.*/$1 $2/' file

复制代码

zsszss0000

受教了

ly5066113 发表于 2015-02-04 13:07
回复 6# zsszss0000

jason680

回复 1# xuzhou2015


$ sed -r 's/^.*,("y":[^,]+),.*("x":[^,]+),.*/\2, \1/' FILE
"x":117.29631, "y":31.86403
"x":117.29751, "y":31.86373

$ perl -pe 's/^.*,("y":[^,]+),.*("x":[^,]+),.*/\2, \1/' FILE
"x":117.29631, "y":31.86403
"x":117.29751, "y":31.86373

$ perl -lane '{$s="";$s=($s?"$1, $s":$1) while(m/("[xy]":[^,]+)/g);print $s}' FILE
"x":117.29631, "y":31.86403
"x":117.29751, "y":31.86373

stupid_lee

回复 7# ly5066113

我也学习了