合并行并插入逗号

紫风8824

求教：
>Potri.010G1602 969 99996 104 specific cd04300 GT1_Glycogen_Phosphorylase 0 1224.62
>Potri.010G1602 969 263942 104 superfamily cl10013 Glycosyltransferase_GTB_type 0 1224.62
>Potri.010G1602 969 233722 107 multidom TIGR02093 P_ylase 0 1111.18
>Potri.010G1602 973 99996 104 specific cd04300 GT1_Glycogen_Phosphorylase 0 1218.85
>Potri.010G1602 973 263942 104 superfamily cl10013 Glycosyltransferase_GTB_type 0 1218.85
>Potri.010G1602 973 233722 107 multidom TIGR02093 P_ylase 0 1105.79
变成：
>Potri.010G1602 969 99996,104,specific,cd04300,,,GT1_Glycogen_Phosphorylase,0,1224.62  263942,104,superfamily,cl10013,,,Glycosyltransferase_GTB_type,0,1224.62  233722,107,multidom,,,TIGR02093 P_ylase,0,1111.18
>Potri.010G1602 973 99996,104,specific,cd04300,,,GT1_Glycogen_Phosphorylase,0,1218.85 263942,104,superfamily,cl10013,,,Glycosyltransferase_GTB_type,0,1218.85 233722,107,multidom,TIGR02093,,,P_ylase,0,1105.79
请大神指教~谢谢！

Herowinter

回复 1# 紫风8824
第一列固定吗？合并条件是第一列 第二列都相同还是第二列相同？

   

Kasiotao

1. awk -v flag=0 '{if($2!=flag){if(NR!=1){printf "\n"}printf $1" "$2" ";flag=$2}printf $3","$4","$5","$6",,,"$7","$8","$9" "}' testfile

复制代码

试试 是不是你要的效果

Herowinter

回复 1# 紫风8824

1. awk '{s=$3;for(i=4;i<=NF;i++){if(i!=7)s=s","$i;else s=s",,,"$i};a[$1" "$2]=length(a[$1" "$2])?a[$1" "$2]" "s:s} END{for(i in a)print i,a[i]|"sort -nk2,2"}' i
   
2. >Potri.010G1602 969 99996,104,specific,cd04300,,,GT1_Glycogen_Phosphorylase,0,1224.62 263942,104,superfamily,cl10013,,,Glycosyltransferase_GTB_type,0,1224.62 233722,107,multidom,TIGR02093,,,P_ylase,0,1111.18
   
3. >Potri.010G1602 973 99996,104,specific,cd04300,,,GT1_Glycogen_Phosphorylase,0,1218.85 263942,104,superfamily,cl10013,,,Glycosyltransferase_GTB_type,0,1218.85 233722,107,multidom,TIGR02093,,,P_ylase,0,1105.79

复制代码

huang6894

回复 1# 紫风8824

1. awk -vOFS=',' '{for(i=1;i++<=NF;)a[$1","$2]=a[$1","$2]","$i}END{for(b in a){sub(/,$/,"",a[b]);print b"\n"a[b]}}' hh
   
2. >Potri.010G1602,973
   
3. ,973,99996,104,specific,cd04300,GT1_Glycogen_Phosphorylase,0,1218.85,,973,263942,104,superfamily,cl10013,Glycosyltransferase_GTB_type,0,1218.85,,973,233722,107,multidom,TIGR02093,P_ylase,0,1105.79
   
4. >Potri.010G1602,969
   
5. ,969,99996,104,specific,cd04300,GT1_Glycogen_Phosphorylase,0,1224.62,,969,263942,104,superfamily,cl10013,Glycosyltransferase_GTB_type,0,1224.62,,969,233722,107,multidom,TIGR02093,P_ylase,0,1111.18

复制代码

用户名注册后不能更改

回复 4# Herowinter

看楼主的三个逗号我有点没明白这逻辑，然后看你的结果是正确的，再一看命令……

紫风8824

回复 3# Kasiotao
谢谢~ 可以

紫风8824

回复 2# Herowinter
合并条件是第一列、第二列都相同再合并~


   

yestreenstars

1. sed -r ':1;N;s/^(\S+\s+\S+\b)(.*)\n\1(.*)/\1\2\3/;t1;P;D'

复制代码

zxy877298415

回复 9# yestreenstars

大师楼主还有三个逗号的需求了