用sed或awk如何实现

我是一隻羊

回复 10# xiaoshichao143


    你们都不贴原文本....贴出来的部分也不具有代表性....字符处理这么精确的事情当然结果会有偏差...

lifayi2008

1. test@ubuntu-test:~/test$ cat test.txt
   
2. ------------------------------------------------
   
3. sLanguage|sServiceID|nSPID|nServiceCode|sMemo|sLangTypeAbbr|sUsed|nSMSCodeSchema|sNBLangID
   
4. ------------------------------------------------
   
5. 142|-1|-1|1|Chinese|cn|1|1|01
   
6. 01|-1|-1|1|Memo|CN|1|2|2
   
7. 02|-1|-1|1|Memo|CN|1|2|2
   
8. 143|-1|-1|1|Language type memo|chi|1|1|06
   
9. 144|-1|-1|1|Language type memo|eng|1|1|06
   
10. 145|-1|-1|1|Language type memo|spa|1|1|06
    
11. test@ubuntu-test:~/test$ awk -F"|" '!/^-*$/{if(a){print a,$1;next}{a=$1}}' test.txt
    
12. sLanguage 142
    
13. sLanguage 01
    
14. sLanguage 02
    
15. sLanguage 143
    
16. sLanguage 144
    
17. sLanguage 145

复制代码

jcdiy0601

1. awk -F"|" '{if($1~/sLanguage/) name=$1;if($1~/[0-9]/)print name,$1}' 1

复制代码

liion631818

1. lee@lee-HP-ProBook-4416s:~$ echo '------------------------------------------------
   
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' | awk -F '\|' '/sLanguage/{for(i=0; i<NF;i++)if($i=="sLanguage")col=i;next}NF>1{print "sLanguage " $col}'
   
10. sLanguage 142
    
11. sLanguage 01
    
12. sLanguage 02
    
13. sLanguage 143
    
14. sLanguage 144
    
15. sLanguage 145
    

复制代码

回复 1# xiaoshichao143


   

sky_eminem

awk 'BEGIN{FS="|";NR=4}{print "sLanguage   " $1}' a.txt

xiaoshichao143

回复 15# sky_eminem


    这个不通用，只适用于当前表。

dengwei29

1. sed -r '/[a-z]/!d;s!([^|]+).*!\1!;/[a-z]/{h;d};G;s!(.*)\n(.*)!\2: \1!' file

复制代码

klainogn

1. sed -rn 's/\|.*$//;ta;d;:a;/^[0-9]/{G;s/(.*)\n(.*)/\2 \1/;p;d};h' urfile

复制代码

zl624867243

其他人解决方式我就没看了先写上我的

1. 
   
2. #!/bin/bash
   
3. a=`awk -F '|' '{print $1}' file | tail -6 > 1.txt`
   
4. for i in `cat 1.txt`
   
5. do
   
6. echo "sLanguage"  $i
   
7. done
   
8. rm -rf 1.txt

复制代码