有两个文件：

文件A:

BP00041754,gonet
BP00041784,ajarw
BP00041870,thienlas

文件B:

BP00041754,adfdf,2007/03/17
BP00041754,adffknfa,2007/03/17
BP00041754,jasdjfaj,2007/01/17
BP00041784,ajasdfj,2007/02/13
BP00041870,eruioqt,2007/05/07
BP00041870,jvnza, 2007/03/17

想要合并，变成：

BP00041754,gonet,adfdf,2007/03/17
BP00041754,gonet,adffknfa,2007/03/17
BP00041754,gonet,jasdjfaj,2007/01/17
BP00041784,ajasdfj,ajasdfj,2007/02/13
BP00041870,thienlas,eruioqt,2007/05/07
BP00041870,thienlas,jvnza, 2007/03/17

也就是在文件A中找到key后,将其后面的值插入到文件B中

awk ‘BEGIN{FS=OFS=”,”}NR==FNR{a[$1]=$0}NR!=FNR{if(a[$1]){$1=a[$1]};print}’ fileA fileB

This entry was posted on 星期三, 11月 21st, 2007 at 1:59 pm and is filed under Shell. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.