LinuxSir.cn,穿越时空的Linuxsir!

 找回密码
 注册
搜索
热搜: shell linux mysql
查看: 1062|回复: 2

请教,sed处理特殊控制字符的问题?从access中转换出来的数据,包含有一些特殊控制符,怎样

[复制链接]
发表于 2008-8-8 12:49:40 | 显示全部楼层 |阅读模式
[root@cu01 ~]# sed '1,$l' xaa
1.00,.89,4.61,"\311\275\313\311\314\250\267\371","K52E004022",.00,1.3\
0,"2004","\263\244\260\327\311\275","\266\253\261\261","\272\332\301\
\372\275\255"$
1.00,.89,4.61,"\u027d\uffff\uffff\u0328\uffff\uffff","K52E004022",.00,1.30,"2004","\uffff\uffff\uffff\uffff\u027d","\uffff\uffff\uffff\uffff","\uffff\uffff\uffff
2.00,27.01,35.76,"\311\275\313\311\314\250\267\371","K52E004022",1.50\
,1.30,"2004","\263\244\260\327\311\275","\266\253\261\261","\304\332\
\303\311\271\305"$
2.00,27.01,35.76,"\u027d\uffff\uffff\u0328\uffff\uffff","K52E004022",1.50,1.30,"2004","\uffff\uffff\uffff\uffff\u027d","\uffff\uffff\uffff\uffff","\uffff\uffff\uffff\u0279\uffff"
3.00,1.37,7.56,"\260\315\300\255\260\315\312\262\267\371","K52E005022\
",.00,1.30,"2004","\263\244\260\327\311\275","\266\253\261\261","\274\
\252\301\326"$
3.00,1.37,7.56,"\uffff\uffff\uffff\uffff\uffff\uffff\u02b2\uffff\uffff","K52E005022",.00,1.30,"2004","\uffff\uffff\uffff\uffff\u027d","\uffff\uffff\uffff\uffff","\uffff\uffff\uffff\uffff"
4.00,318.93,74.74,"\316\367\315\301\303\305\327\323\267\371","K52E005\
021",4.00,1.30,"2004","\263\244\260\327\311\275","\266\253\261\261","\
\301\311\304\376"$
4.00,318.93,74.74,"\uffff\uffff\uffff\uffff\uffff\uffff\uffff\u04f7\uffff","K52E005021",4.00,1.30,"2004","\uffff\uffff\uffff\uffff\u027d","\uffff\uffff\uffff\uffff","\uffff\uffff\uffff\uffff"
5.00,227.95,63.84,"\300\346\312\367\271\265\267\371","K52E006021",3.5\
0,1.30,"2004","\263\244\260\327\311\275","\266\253\261\261","\274\252\
\301\326"$
5.00,227.95,63.84,"\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff","K52E006021",3.50,1.30,"2004","\uffff\uffff\uffff\uffff\u027d","\uffff\uffff\uffff\uffff","\uffff\uffff\uffff\uffff"
[root@cu01 ~]#

然后我使用
[root@cu01 ~]# sed '1,$l' xaa|sed 's/\\[1-9]*// g'
1.00,.89,4.61,"0","K52E004022",.00,1.3
0,"2004","0","","01
"$
1.00,.89,4.61,"\u027d\uffff\uffff\u0328\uffff\uffff","K52E004022",.00,1.30,"2004","\uffff\uffff\uffff\uffff\u027d","\uffff\uffff\uffff\uffff","\uffff\uffff\uffff
2.00,27.01,35.76,"0","K52E004022",1.50
,1.30,"2004","0","","04
0305"$
2.00,27.01,35.76,"\u027d\uffff\uffff\u0328\uffff\uffff","K52E004022",1.50,1.30,"2004","\uffff\uffff\uffff\uffff\u027d","\uffff\uffff\uffff\uffff","\uffff\uffff\uffff\u0279\uffff"
3.00,1.37,7.56,"0000","K52E005022
",.00,1.30,"2004","0","","
01"$
3.00,1.37,7.56,"\uffff\uffff\uffff\uffff\uffff\uffff\u02b2\uffff\uffff","K52E005022",.00,1.30,"2004","\uffff\uffff\uffff\uffff\u027d","\uffff\uffff\uffff\uffff","\uffff\uffff\uffff\uffff"
4.00,318.93,74.74,"010305","K52E005
021",4.00,1.30,"2004","0","","
0104"$
4.00,318.93,74.74,"\uffff\uffff\uffff\uffff\uffff\uffff\uffff\u04f7\uffff","K52E005021",4.00,1.30,"2004","\uffff\uffff\uffff\uffff\u027d","\uffff\uffff\uffff\uffff","\uffff\uffff\uffff\uffff"
5.00,227.95,63.84,"00","K52E006021",3.5
0,1.30,"2004","0","","
01"$
5.00,227.95,63.84,"\uffff\uffff\uffff\uffff\uffff\uffff\uffff\uffff","K52E006021",3.50,1.30,"2004","\uffff\uffff\uffff\uffff\u027d","\uffff\uffff\uffff\uffff","\uffff\uffff\uffff\uffff"
[root@cu01 ~]#

根本没有处理掉啊,怎么解决?期待
发表于 2008-9-25 14:01:29 | 显示全部楼层
已经处理掉一些了呀.
回复 支持 反对

使用道具 举报

发表于 2008-9-26 11:17:50 | 显示全部楼层
剩下的都是 \u的哦。
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

快速回复 返回顶部 返回列表