论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2009-11-23 18:41 |只看该作者 |倒序浏览

11000501,1,"GMCC"
11000520,1,"GMCC"
11000540,1,"GMCC"
11004401,1,"0"
11004420,2,"$dataarea"
.......
请教一个问题,在这个配置中如何能把前6位相同编号以01结束的第一个参数,用
前6位相同编号以20结束第二个参数进行替换呢?
结果为:
11000501,1,"GMCC"
11000520,1,"GMCC"
11000540,1,"GMCC"
11004401,2,"0"
11004420,2,"$dataarea"
.......

文库|博客

sunbw001

家境小康

论坛徽章:: 0

2楼 [报告]

发表于 2009-11-23 20:09 |只看该作者

awk -F',' 'NR==FNR{if($1~/20$/){sub(/20$/,"",$1);a[$1]=$2}}NR>FNR{c=$1;sub(/[0-9][0-9]$/,"",$1);print c","a[$1]","$3}' data data

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

davidbeckham921

家境小康

论坛徽章:: 1

3楼 [报告]

发表于 2009-11-23 20:31 |只看该作者

原帖由 sunbw001 于 2009-11-23 20:09 发表
awk -F',' 'NR==FNR{if($1~/20$/){sub(/20$/,"",$1);a[$1]=$2}}NR>FNR{c=$1;sub(/[0-9][0-9]$/,"",$1);print c","a[$1]","$3}' data data

我去二楼太狠了！
fnr是东东