如何实现将field1相同的记录的field2合并到一行中？

sayigood

输入：
1 aaa
1 asdf
1 dsafdsa
2 adsf
2 frgfd
2 grsdfg
2 fdsdsaf
3 adfads
3 adsfads
3 23rew
输出：
1 aaa  asdf  dsafds
2 ads  frgfd  grsdfg  fdsdsaf
3 adfads    adsfads  23rew

wmjie

1. awk '{if( seq!=$1 ){printf("\n");seq=$1};if(seq==$1){printf("%s %s ",$1,$2); }}' t.txt

复制代码

lkk2003rty

1. [oracle@s12071 ~]$ cat  file
   
2. 1 aaa
   
3. 1 asdf
   
4. 1 dsafdsa
   
5. 2 adsf
   
6. 2 frgfd
   
7. 2 grsdfg
   
8. 2 fdsdsaf
   
9. 3 adfads
   
10. 3 adsfads
    
11. 3 23rew
    
12. [oracle@s12071 ~]$ awk '{if($1 in a)a[$1]=a[$1]" "$2; else a[$1]=$2}END{for(i in a) print i,a[i]}' file
    
13. 1 aaa asdf dsafdsa
    
14. 2 adsf frgfd grsdfg fdsdsaf
    
15. 3 adfads adsfads 23rew
    
16. [oracle@s12071 ~]$

复制代码

kingoftime3

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

复制代码

版主杀手

lkk2003rty 发表于 2010-11-09 16:28

    能详细解释下吗？谢谢