awk

jason9699

原数据
a1 hdsk1
a1 hdk2
b1 hdk3
a1 hdisk5
a1 hdk6
b1 hdk7
c1 hk8

想要输出结果
a1 hdsk1,hdk2,hdisk5,hdk6
b1 hdk3,hdk7
c1 hk8

请高手指教?

yinyuemi

回复 1# jason9699

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

复制代码

jason9699

好用!多谢!

心乃南部之星

awk '{a[$1]?a[$1]=a[$1]","$2:a[$1]=$2}END{for(i in a )print i,a[i]}' file

jason9699

跟进问问?
原数据
a1 hdsk1
a1 hdk2
b1 hdk3
a1 hdisk5
a1 hdk6
b1 hdk7
c1 hk8
b1


想要输出结果
a1 hdsk1,hdk2,hdisk5,hdk6
b1 hdk3,hdk7
c1 hk8

现在出来的类似
a1 hdsk1,hdk2,hdisk5,hdk6
b1 hdk3,hdk7,
c1 hk8

b1 hdk3,hdk7, 不想要这个,

有办法么?谢谢

Shell_HAT

回复 5# jason9699

1. awk '{a[$1]=a[$1]?a[$1]","$2:$0}END{for(i in a)print a[i]}' urfile | sed 's/,$//'

复制代码

WilliBhamlll

回复 5# jason9699

1. awk '$2{a[$1]=a[$1]?a[$1]","$2:$0}END{for(i in a)print a[i]}' file

复制代码

jason680

回复 5# jason9699

# awk 'NF==2{a[$1]=a[$1]==""?$2:a[$1]","$2}END{for(n in a)print n,a[n]}' FILE
a1 hdsk1,hdk2,hdisk5,hdk6
b1 hdk3,hdk7
c1 hk8

   

jason9699

回复 8# jason680


    果然高手众多,这个好用,但我没描述好
跟进问问?
原数据
a1 hdsk1
a1 hdk2
b1 hdk3
a1 hdisk5
a1 hdk6
b1 hdk7
c1 hk8
b1
c2
  


想要输出结果
a1 hdsk1,hdk2,hdisk5,hdk6
b1 hdk3,hdk7
c1 hk8
c2


现在出来的类似
a1 hdsk1,hdk2,hdisk5,hdk6
b1 hdk3,hdk7,
c1 hk8


b1 hdk3,hdk7, 不想要这个, 但c2还要.貌似没有c2

有办法么?谢谢

yinyuemi

回复 9# jason9699

1. awk 'a[$1]&&NF==1{next}{a[$1]=a[$1]?a[$1]","$2:$0}END{for(i in a)print a[i]}'

复制代码