怎么将窄表变成宽表

hamling

原始文件（各行可能不一定按顺序）

3101F 001002
3101C 003004
3101Y 005006
3102F 088089
3102C 003004
3102Y 003003

输出文件：
3101 001002,003004,005006
3102 088089,003004,003003

hamling

首次发帖，大虾支持啊，希望awk可以搞定

LikeLx

1. awk -F '[A-Z]' '{a[$1]=a[$1]?a[$1]","$2:$2}END{for(i in a) print i,a[i]}'

复制代码

jason680

回复 1# hamling

$ awk '{sub(/[^0-9]+$/,"",$1);a[$1]=a[$1]?a[$1]","$2:$2}END{t=asorti(a,b);for(n=1;n<=t;n++)print b[n],a[b[n]]}' FILE
3101 001002,003004,005006
3102 088089,003004,003003

   

yestreenstars

1. awk '{sub(/[^0-9]+/,"",$1);a[$1]=a[$1]!=""?a[$1]","$2:$0}END{for(i in a)print a[i]}'

复制代码

ly5066113

回复 1# hamling


try：

1. sed -r ':a;N;s/^([0-9]+).?( .*)\n\1. (.*)/\1\2,\3/;ta;P;D' file

复制代码

nathanielwen

点赞~回复 5# yestreenstars