免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2491 | 回复: 3

[文本处理] 如何替换末尾的东西? [复制链接]

论坛徽章:
0
发表于 2012-08-06 11:27 |显示全部楼层
有一个文本文件:
INSERT INTO "DS"."A_RCVBL_FLOW_BAK" ("RCVBL_AMT_ID","CALC_ID","AMT_TYPE","RCVBL_YM","CONS_NO","ORG_NO","PAY_MODE","T_PQ","RCVBL_AMT"
,"RCVED_AMT","STATUS_CODE","SETTLE_FLAG","PENALTY_BGN_DATE","RCVBL_INPRICE_AMT","RCVBL_PL_AMT","RCVED_IN_PRICE_AMT","RCVED_PL_AMT","
RCVBL_PENALTY","RCVED_PENALTY","RISK_LEVEL_CODE","RELEASE_DATE","ACCT_NO","OWE_AMT") VALUES (50241344577,50239441864,'01','201202','
7531720025','344150306','0101',0,0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000,0.00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000,'01','03',TO_DATE('2012-03-21','YYYY-MM-DD'),0.000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000,0.0000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000,0.00000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000,0.000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000,0.0000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000,0.00000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000,'01','20120207','50107919298',0.000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);--AABmWoADSAAGRGMAAA

怎么把--AABmWoADSAAGRGMAAA替换成空的?

论坛徽章:
5
2015年辞旧岁徽章
日期:2015-03-03 16:54:152015年迎新春徽章
日期:2015-03-04 09:50:282015年亚洲杯之朝鲜
日期:2015-03-13 22:47:33IT运维版块每日发帖之星
日期:2016-01-09 06:20:00IT运维版块每周发帖之星
日期:2016-03-07 16:27:44
发表于 2012-08-06 11:44 |显示全部楼层
  1. sed 's/--AABmWoADSAAGRGMAAA//g' urfile
复制代码
??

论坛徽章:
5
未羊
日期:2014-08-04 16:15:21天秤座
日期:2014-08-13 13:52:372015年辞旧岁徽章
日期:2015-03-03 16:54:152015年迎新春徽章
日期:2015-03-04 09:56:112015亚冠之浦和红钻
日期:2015-06-29 15:30:48
发表于 2012-08-06 11:54 |显示全部楼层
  1. awk -F "--" '{print $1}'
复制代码
我觉得没这么简单吧。。。。

论坛徽章:
0
发表于 2012-08-06 13:20 |显示全部楼层
去掉sql注释的意思咯?
  1. personball@vostro:~$echo 'abcd --sdf'|sed 's/--.*$//'
  2. abcd
  3. personball@vostro:~$
复制代码
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP