awk或者sed如何處理這樣的問題

wjw870907

cat file
gidNumber: 820
cn: icac
memberUid: aaa
memberUid: bbb
memberUid: ccc
gidNumber: 821
cn: datax
memberUid: ddd
memberUid: aaa
gidNumber: 822
cn: exchange
這里是3條記錄
一個(gè)文件里gidNumber和cn 是肯定有的，memberUid可能有多個(gè)也可能沒有，如何做到
gidNumber: 820,cn: icac,memberUid: aaa|bbb|ccc
gidNumber: 821,cn: datax,memberUid: ddd|aaa
gidNumber: 822,cn: exchange,

wjw870907

有高手嗎有高手嗎有高手嗎

Looiml

sed -nr '1h;1!H;${g;:a;s/(memberUid: )([^\n]+)\n\1/\1\2|/;ta;s/\n(cn|mem)|$/,\1/g;p}' file
gidNumber: 820,cn: icac,memberUid: aaa|bbb|ccc
gidNumber: 821,cn: datax,memberUid: ddd|aaa
gidNumber: 822,cn: exchange,

Looiml

1. awk -F'[: ]+' '/^mem/{printf a?"|"$2:$0;a=1;next}{a=0;if(/^gid/)print "";printf $0","}' file

復(fù)制代碼

gidNumber: 820,cn: icac,memberUid: aaa|bbb|ccc
gidNumber: 821,cn: datax,memberUid: ddd|aaa
gidNumber: 822,cn: exchange,

wjw870907

Looiml 發(fā)表于 2020-03-06 20:01
gidNumber: 820,cn: icac,memberUid: aaa|bbb|cccgidNumber: 821,cn: datax,memberUid: ddd|aaagidNumber:  ...

謝謝大神

wh7211

回復(fù) 1# wjw870907

1. cat 1
   
2. gidNumber: 820
   
3. cn: icac
   
4. memberUid: aaa
   
5. memberUid: bbb
   
6. memberUid: ccc
   
7. gidNumber: 821
   
8. cn: datax
   
9. memberUid: ddd
   
10. memberUid: aaa
    
11. gidNumber: 822
    
12. cn: exchange
    
13. 
    
14. awk '/^gidNumber/{if(a){print a;a=b=""};a=$0}/^cn/{a=a","$0","}/^memberUid/{a=b?a"|"$2:a""$0;b++}END{if(a){print a}}' 1
    
15. awk '/^gidNumber/{a[++b]=$0;c=""}/^cn/{a[b]=a[b]","$0","}/^memberUid/{a[b]=c?a[b]"|"$2:a[b]""$0;c++}END{for(i=1;i<=length(a);i++){print a[i]}}' 1
    
16. 
    
17. # 輸出。
    
18. gidNumber: 820,cn: icac,memberUid: aaa|bbb|ccc
    
19. gidNumber: 821,cn: datax,memberUid: ddd|aaa
    
20. gidNumber: 822,cn: exchange,

復(fù)制代碼

ll251

1. sed -r '/^gidNumber/{:a;N;/\ngidNumber/bc;/\ncn/{s/$/,/;s/\n//};s/memberUid: (.*)\n/\1|/;s/\n//;ta;:c;s/([a-z|\|]+)(memberUid: )/\2\1/;P;D}' 1

復(fù)制代碼

klainogn

1. sed -r '1{h;d};${H;g;b1};/gidNumber/!{H;d};:1;x;s/\n/,/g;:2;s/(memberUid: )([^,]+),\1/\1\2|/;t2' test.txt
   
2. gidNumber: 820,cn: icac,memberUid: aaa|bbb|ccc
   
3. gidNumber: 821,cn: datax,memberUid: ddd|aaa
   
4. gidNumber: 822,cn: exchange

復(fù)制代碼

klainogn

1. awk '/gidNumber/{if(length(s)!=0)print s;s=$0;next}s~/member/{s=s"|"$2;next}{s=s","$0}END{print s}' test.txt

復(fù)制代碼