如果筛选字段呢?

netlogon

1. username: zhengzhu
   
2. add: china
   
3. age: 23
   
4. pass: yes
   
5. marry: yes
   
6. tel: 2312423
   
7. 
   
8. username: gsdfsdf
   
9. add: USA
   
10. age: 34
    
11. pass: yes
    
12. tel: 9878676
    
13. 
    
14. username: zhk
    
15. add: china
    
16. age: 50
    
17. pass: no
    
18. live: guangzhou

复制代码

如上的文件中,我需要的最终结果如下:

1. zhengzhu china 23 yes
   
2. gsdfsdf        USA 34        yes
   
3. zhk        china        50        no

复制代码

谢谢.

netlogon

是不是需要定义ORS呢?
但是ORS应该设为什么呢?

liying_gg

1. user@ubuntu:~/script$ awk 'BEGIN{FS=":"}{if($0~"^$") print $0;else printf $2}' file|cut -d " " -f2-5
   
2. zhengzhu china 23 yes
   
3. gsdfsdf USA 34 yes
   
4. zhk china 50 no

复制代码

lululau

1. 
   
2. awk -v RS='\n\n' -v FS=': |\n' '{print $2" "$4" "$6" "$8}'
   

复制代码

netlogon

原帖由 lululau 于 2010-1-8 18:12 发表

awk -v RS='\n\n' -v FS=': |\n' '{print $2" "$4" "$6" "$8}'

但是有些字段是不一样的排列顺序:

1. 
   
2. username: zhengzhu
   
3. add: china
   
4. age: 23
   
5. pass: yes
   
6. marry: yes
   
7. tel: 2312423
   
8. 
   
9. username: gsdfsdf
   
10. add: USA
    
11. age: 34
    
12. pass: yes
    
13. tel: 9878676
    
14. 
    
15. username: zhk
    
16. add: china
    
17. age: 50
    
18. pass: no
    
19. live: guangzhou
    
20. 
    
21. username: jacky
    
22. add: china
    
23. tel: 89873
    
24. age: 50
    
25. email: [email]jacky@163.com[/email]
    
26. pass: no
    
27. live: guangzhou
    
28. 
    
29. username: juny
    
30. add: CA
    
31. age: 50
    
32. email: [email]jacky@163.com[/email]
    
33. pass: no
    
34. live: BG
    

复制代码

Shell_HAT

1. 
   
2. awk '/^username:/||/^add:/||/^age:/||/^pass:/{print $2}' urfile | awk '{ORS=NR%4?" ":"\n";print $NF}'
   

复制代码

lululau

1. 
   
2. perl -ne '
   
3. BEGIN{$/="\n\n";$,=" "}
   
4. my $h;
   
5. for(split /\n/){
   
6. @r = split /: /;
   
7. $h->{$r[0]}=$r[1];
   
8. }
   
9. push @$a, $h;
   
10. END{print $_->{username}, $_->{add}, $_->{age}, $_->{pass}, "\n" for @$a;}
    

复制代码

ywlscpl

1. awk '/username/{if (n) print n,add,age,p;n=$2}/add:/{add=$2}/age:/{age=$2}/pass:/{p=$2}END{print n,add,age,p}' file

复制代码

ghp268

原帖由 ywlscpl 于 2010-1-8 21:34 发表
awk '/username/{if (n) print n,add,age,p;n=$2}/add:/{add=$2}/age:/{age=$2}/pass:/{p=$2}END{print n,add,age,p}' file

这个可读性好

贪睡的小猪

原帖由 ywlscpl 于 2010-1-8 21:34 发表
awk '/username/{if (n) print n,add,age,p;n=$2}/add:/{add=$2}/age:/{age=$2}/pass:/{p=$2}END{print n,add,age,p}' file

能不能解释一下这一段
{if (n) print n,add,age,p;n=$2}