如何填补空缺的列值

jason680

回复 1# KEN6503

try this way ...

$ awk 'NF==1{$3=$1;$1=L}P&&NF>=3{print $1,$3;L=$1}/^___/{P=1}' FILE
autoabl-acbd-able -------
autoabl-acbd-dm-dtdim s(autoabl-acbd-able-ini)
autoabl-acbd-able-stg s(autoabl-acbd-dm-dtdim)
autoabl-acbd-able-dw s(autoabl-acbd-able-stg)
autoabl-acbd-able-dw s(autoabl-acbd-able-ini)
autoabl-acbd-able-ini -------
autoabl-acbd-housekeep s(autoabl-acbd-dm-dtdim)
autoabl-acbd-able-dlar s(autoabl-acbd-able-dw)
autoabl-acbd-dlar-ini s(autoabl-on-biz-run)
autoabl-acbd-dlar-dw-dum s(autoabl-on-biz-by)
autoabl-acbd-dlar-dw s(autoabl-acbd-dlar-ini)

wh7211

回复 1# KEN6503

1. awk 'NR>1{$0=NF==1?a" "$1:NF==3?$1" "$3:NF==7?$1" "$2" "$5" "$6" "$7:$0;a=$1}1' file
   
2.                                     Job Dependency Report
   
3. 
   
4. 
   
5. Job Name Atomic Start Conditions
   
6. ______________________________ _______________________
   
7. 
   
8. 
   
9. autoabl-acbd-able -------
   
10. autoabl-acbd-dm-dtdim s(autoabl-acbd-able-ini)
    
11. autoabl-acbd-able-stg s(autoabl-acbd-dm-dtdim)
    
12. autoabl-acbd-able-dw s(autoabl-acbd-able-stg)
    
13. autoabl-acbd-able-dw s(autoabl-acbd-able-ini)
    
14. autoabl-acbd-able-ini -------
    
15. autoabl-acbd-housekeep s(autoabl-acbd-dm-dtdim)
    
16. autoabl-acbd-able-dlar s(autoabl-acbd-able-dw)
    
17. autoabl-acbd-dlar-ini s(autoabl-on-biz-run)
    
18. autoabl-acbd-dlar-dw-dum s(autoabl-on-biz-by)
    
19. autoabl-acbd-dlar-dw s(autoabl-acbd-dlar-ini)

复制代码

jason680

回复 4# KEN6503

http://bbs.chinaunix.net/thread-2309494-1-1.html

jason680

回复 8# KEN6503

awk '[pattern]{action}[pattern]{action}...'

awk 'NF==1{$3=$1;$1=L}P&&NF>=3{print $1,$3;L=$1}/^___/{P=1}' FILE