awk 求救

moperyblue

回复 10# hbiczuo

1. sed -r 's/\s//g;:a;s/(([^,]*,){2})(([^,]*,){3}[^,]*),/\1 \3\n\1/M;ta;s/.*\n([^,]*,){2}/& /'

复制代码

k1,k2, v1a,v1b,v1c,v1d
k1,k2, v2a,v2b,v2c,v2d
k1,k2, vna,vnb,vnc,vnd

jcdiy0601

1. awk 'BEGIN{FS=", "}{for(i=2;i<=NF;i++)print $1","$i}' file

复制代码

jason680

回复 1# hbiczuo

$ awk -F, -vkn=2 -vtn=4 -vOFS=", " '{gsub(", *",",");k=$1;for(n=2;n<=kn;++n)k=k OFS $n;for(n=kn+1;n<=NF;n+=tn){t=$n;for(m=1;m<tn&&n+m<=NF;++m)t=t OFS $(n+m);print k,t}}' FILE
k1, k2, v1a, v1b, v1c, v1d
k1, k2, v2a, v2b, v2c, v2d
...
k1, k2, vna, vnb, vnc, vnd   
k1, k2, v1a, v1b, v1c, v1d
k1, k2, v2a, v2b, v2c, v2d
...
k1, k2, vna, vnb, vnc, vnd