文本处理求助

bikkuri

大家好！我想从下面一个报表文件中取数据，源文件如下：

1. Employee No.: PA0152827
   
2. Education:College
   
3. Name:"Wang Jian Hua"
   
4. Sex:Male
   
5. Age:30
   
6. Postion:Sales Manager
   
7. 
   
8. Employee No.: ST0075384
   
9. Education:College
   
10. Name:"Dong Qing"
    
11. Sex:Female
    
12. Age:28
    
13. Postion:Sales Assistant
    
14. ...
    
15. ...
    
16. 
    

复制代码

希望对Employee No，Name和Age三个字段取数据，生成以下格式的输出：

1. PA0152827*Wang Jian Hua*30
   
2. ST0075384*Dong Qing*28
   
3. ...
   

复制代码

谢谢。

yestreenstars

1. awk -F: -vOFS='*' '/^Em/{a=substr($2,2)}/^N/{gsub(/"/,"");b=$2}/^A/{print a,b,$2}'

复制代码

这个冬天不冷

1. [root@everIover ~]# awk -F ":" '/Employee No/{printf("%s*",$2)}/Name/{gsub(/[""]/,"",$2);printf("%s*",$2)}/Age/{print $2}' a.txt
   
2. PA0152827*Wang Jian Hua*30
   
3. ST0075384*Dong Qing*28
   
4. [root@everIover ~]# cat a.txt
   
5. Employee No.: PA0152827
   
6. Education:College
   
7. Name:"Wang Jian Hua"
   
8. Sex:Male
   
9. Age:30
   
10. Postion:Sales Manager
    
11. 
    
12. Employee No.: ST0075384
    
13. Education:College
    
14. Name:"Dong Qing"
    
15. Sex:Female
    
16. Age:28
    
17. Postion:Sales Assistant
    

复制代码

jason680

回复 1# bikkuri

$ awk -F': *' '{gsub(/"/,"")}/^Employee/{E=$2}/^Name/{N=$2}/^Age/{print E"*"N"*"$2}' FILE
PA0152827*Wang Jian Hua*30
ST0075384*Dong Qing*28

TasteOracle

1. grep -oP "(?<=No...|Name..|Age.)[^\"]+" file|xargs -n 3|tr " " "*"

复制代码

dn833

1. awk 'BEGIN{RS="\n\n";FS=":|\n";OFS="*"}{gsub(/\"/,"");print $2,$6,$10}'

复制代码

yjh777

awk 'BEGIN{RS=""; FS="\n"} {print $1, $3, $5}'  $urfile | sed -r -e 's/Employee No.: //' -e 's/(Name|Age)://'