用sed或awk如何实现

xiaoshichao143

1. ------------------------------------------------
   
2. sLanguage|sServiceID|nSPID|nServiceCode|sMemo|sLangTypeAbbr|sUsed|nSMSCodeSchema|sNBLangID
   
3. ------------------------------------------------
   
4. 142|-1|-1|1|Chinese|cn|1|1|01
   
5. 01|-1|-1|1|Memo|CN|1|2|2
   
6. 02|-1|-1|1|Memo|CN|1|2|2
   
7. 143|-1|-1|1|Language type memo|chi|1|1|06
   
8. 144|-1|-1|1|Language type memo|eng|1|1|06
   
9. 145|-1|-1|1|Language type memo|spa|1|1|06

复制代码

上面的内容，如何用sed或awk，使输出为：

1. sLanguage 142
   
2. sLanguage 01
   
3. sLanguage 02
   
4. sLanguage 143
   
5. sLanguage 144
   
6. sLanguage 145

复制代码

zsszss0000

1. awk -vFS="|" '!/^-/{print $1}' file | awk 'NR==1{a=$0;next}{printf a":"$1"\n"}'

复制代码

1. sLanguage:142
   
2. sLanguage:01
   
3. sLanguage:02
   
4. sLanguage:143
   
5. sLanguage:144
   
6. sLanguage:145

复制代码

zxy877298415

1. awk -F\| '/^[^-]/{if(NR==3) {t=$1} else {print t,$1}}' file

复制代码

回复 1# xiaoshichao143


   

zsszss0000

NR==2回复 3# zxy877298415


   

zxy877298415

回复 4# zsszss0000
横线下面有空行！


   

undead244

方法很笨。。。
awk -F "|" '{if(NR==2){head=$1}else if(NR>3){print head" "$1}}' filename

stupid_lee

1. [root@oracle ~]# awk -F"|" 'NR==2{a=$1;next}NR>3{print a" "$1}' ss.txt
   
2. sLanguage 142
   
3. sLanguage 01
   
4. sLanguage 02
   
5. sLanguage 143
   
6. sLanguage 144
   
7. sLanguage 145

复制代码

想要写个sed真的好难，写完再看看羊神为啥这么短

1. sed '/^[^-]/{2{s/^([^|]*)\|(.*)/\1/g;h};4,${s/^([^|]*)\|(.*)/\1/g;G;s/(.*)\n(.*)/\2 \1/g;p}}' -nr

复制代码

我是一隻羊

来个sed版...

1. sed -r '/---/{N;N;s/-+\n|\|.*//g;h;d};G;s/([^|]+).*\n(.*)/\2 \1/' inputfile

复制代码

补一个awk版

1. awk -F\| -vf=1 'NR==2{split($0,a,"|")}NR>3{print a[f],$f}' inputfile

复制代码

f那里定义你要取的域.

xiaoshichao143

回复 2# zsszss0000


    多谢大家的热心解答，就不一一答谢了。多谢!!

xiaoshichao143

1. <1365 szxciscslx23114 [bmp] :/home/bmp/xiaoshichao>set ModuleName="CommTableSOAP"
   
2. <1366 szxciscslx23114 [bmp] :/home/bmp/xiaoshichao>set TableName="R_CommTable_Language"
   
3. <1367 szxciscslx23114 [bmp] :/home/bmp/xiaoshichao>
   
4. <1367 szxciscslx23114 [bmp] :/home/bmp/xiaoshichao>set ModuleInfo=`awk -F'|' -v module="$ModuleName" '$1 == module{print "-neid "$3" -netElementType "$4" -moduleName  "$1" -version "$2}' ${ENIP_HOME}/app/modules/moduleversion.txt`
   
5. <1368 szxciscslx23114 [bmp] :/home/bmp/xiaoshichao>awk -v moduleInfo="$ModuleInfo" -v table="$TableName" 'BEGIN{print "etool -c \"moduleadm propertyManagement -queryTable "moduleInfo" -tableName "table"\""}' | sh
   
6. 
   
7. ------------------------------------------------
   
8. sLanguage|sServiceID|nSPID|nServiceCode|sMemo|sLangTypeAbbr|sUsed|nSMSCodeSchema|sNBLangID
   
9. ------------------------------------------------
   
10. 142|-1|-1|1|Chinese|cn|1|1|01
    
11. 01|-1|-1|1|Memo|CN|1|2|2
    
12. 02|-1|-1|1|Memo|CN|1|2|2
    
13. 143|-1|-1|1|Language type memo|chi|1|1|06
    
14. 144|-1|-1|1|Language type memo|eng|1|1|06
    
15. 145|-1|-1|1|Language type memo|spa|1|1|06
    
16. 
    
17. <1369 szxciscslx23114 [bmp] :/home/bmp/xiaoshichao>awk -v moduleInfo="$ModuleInfo" -v table="$TableName" 'BEGIN{print "etool -c \"moduleadm propertyManagement -queryTable "moduleInfo" -tableName "table"\""}' | sh | sed -r '/---/{N;N;s/-+\n|\|.*//g;h;d};G;s/([^|]+).*\n(.*)/\2 \1/'
    
18. 
    
19. 
    
20. sLanguage 142
    
21. sLanguage 01
    
22. sLanguage 02
    
23. sLanguage 143
    
24. sLanguage 144
    
25. sLanguage 145
    
26. 
    
27. sLanguage
    
28. <1370 szxciscslx23114 [bmp] :/home/bmp/xiaoshichao>

复制代码

回复 8# 我是一隻羊

sed的如果有空行的话，会有一点小问题。