文本处理_如何实现某列两个数字间相差多少就插入多少空行

hechao7021

a.txt
1 1006 + 0 2 CHH CCC U L L L L L
1 1007 + 0 2 CHH CCT U L L L L L
1 1008 + 0 2 CHH CTA U L L L L L
1 1013 + 0 2 CHH CCC U L L L L L
1 1014 + 0 2 CHH CCT U L L L L L
1 1015 + 0 2 CHH CTA U L L L L L
1 1020 + 0 2 CHH CCC U L L L L L
1 1021 + 0 2 CHH CCT U L L L L L
1 1022 + 0 2 CHH CTA U L L L L L
1 1027 + 0 2 CHH CCC U L L L L L
1 1028 + 0 2 CHH CCT U L L L L L
1 1029 + 1 2 CHH CTA U L L L L U
如果相邻两行第二列的数字不连续，则在这两行之间添加行，添加的行数等于两列数字的差，得到的结果文件：
1 1006 + 0 2 CHH CCC U L L L L L
1 1007 + 0 2 CHH CCT U L L L L L
1 1008 + 0 2 CHH CTA U L L L L L
   1009
   1010
   1011
   1012
1 1013 + 0 2 CHH CCC U L L L L L
1 1014 + 0 2 CHH CCT U L L L L L
1 1015 + 0 2 CHH CTA U L L L L L
   1016
   1017
   1018
   1019
1 1020 + 0 2 CHH CCC U L L L L L
1 1021 + 0 2 CHH CCT U L L L L L
1 1022 + 0 2 CHH CTA U L L L L L
   1023
   1024
   1025
   1026
1 1027 + 0 2 CHH CCC U L L L L L
1 1028 + 0 2 CHH CCT U L L L L L
1 1029 + 1 2 CHH CTA U L L L L U

csccyab

1. $ awk 'NR>1{do {first=$1; gsub(/./," ",first); count++; if ($2!=count) print first" "count} while ($2>count)}  NR==1{count=$2; first=$1; gsub(/./, " ", first)} 1' a.txt
   
2. 1 1006 + 0 2 CHH CCC U L L L L L
   
3. 1 1007 + 0 2 CHH CCT U L L L L L
   
4. 1 1008 + 0 2 CHH CTA U L L L L L
   
5.   1009
   
6.   1010
   
7.   1011
   
8.   1012
   
9. 1 1013 + 0 2 CHH CCC U L L L L L
   
10. 1 1014 + 0 2 CHH CCT U L L L L L
    
11. 1 1015 + 0 2 CHH CTA U L L L L L
    
12.   1016
    
13.   1017
    
14.   1018
    
15.   1019
    
16. 1 1020 + 0 2 CHH CCC U L L L L L
    
17. 1 1021 + 0 2 CHH CCT U L L L L L
    
18. 1 1022 + 0 2 CHH CTA U L L L L L
    
19.   1023
    
20.   1024
    
21.   1025
    
22.   1026
    
23. 1 1027 + 0 2 CHH CCC U L L L L L
    
24. 1 1028 + 0 2 CHH CCT U L L L L L
    
25. 1 1029 + 1 2 CHH CTA U L L L L U
    

复制代码

hechao7021

回复 2# csccyab
非常感谢您的帮忙，太给力了

hechao7021

回复 2# csccyab

大神，请问如果第一列遇到不同的值，则从头开始插入要怎么做呢？我这样改输不出结果：awk 'NR>1{do {first[NR]=$1; gsub(/./," ",first); count++; if ($2!=count&&first[NR]==first[NR-1]) print first" "count} while ($2>count)}  NR==1{count=$2; first[NR]=$1; gsub(/./, " ", first)} 1' a.txta.txt
1 1006 + 0 2 CHH CCC U L L L L L
1 1007 + 0 2 CHH CCT U L L L L L
1 1008 + 0 2 CHH CTA U L L L L L
1 1013 + 0 2 CHH CCC U L L L L L
2 1005 + 0 2 CHH CCT U L L L L L
2 1009 + 0 2 CHH CTA U L L L L L
2 1010 + 0 2 CHH CCC U L L L L L
2 1012 + 0 2 CHH CCT U L L L L L
3 1002 + 0 2 CHH CTA U L L L L L
3 1017 + 0 2 CHH CCC U L L L L L
3 1018 + 0 2 CHH CCT U L L L L L
3 1020 + 1 2 CHH CTA U L L L L U
变成：
1 1006 + 0 2 CHH CCC U L L L L L
1 1007 + 0 2 CHH CCT U L L L L L
1 1008 + 0 2 CHH CTA U L L L L L
   1009
   1010
   1011
   1012
1 1013 + 0 2 CHH CCC U L L L L L
2 1005 + 0 2 CHH CCT U L L L L L
   1006
   1007
   1008
2 1009 + 0 2 CHH CTA U L L L L L
2 1010 + 0 2 CHH CCC U L L L L L
   1011
2 1012 + 0 2 CHH CCT U L L L L L
3 1017 + 0 2 CHH CCC U L L L L L
3 1018 + 0 2 CHH CCT U L L L L L
   1019
3 1020 + 1 2 CHH CTA U L L L L U

wh7211

回复 1# hechao7021

1. cat 1
   
2. 1 1006 + 0 2 CHH CCC U L L L L L
   
3. 1 1007 + 0 2 CHH CCT U L L L L L
   
4. 1 1008 + 0 2 CHH CTA U L L L L L
   
5. 1 1013 + 0 2 CHH CCC U L L L L L
   
6. 1 1014 + 0 2 CHH CCT U L L L L L
   
7. 1 1015 + 0 2 CHH CTA U L L L L L
   
8. 1 1020 + 0 2 CHH CCC U L L L L L
   
9. 1 1021 + 0 2 CHH CCT U L L L L L
   
10. 1 1022 + 0 2 CHH CTA U L L L L L
    
11. 1 1027 + 0 2 CHH CCC U L L L L L
    
12. 1 1028 + 0 2 CHH CCT U L L L L L
    
13. 1 1029 + 1 2 CHH CTA U L L L L U
    
14. 
    
15. awk '{b=a?$2-a:1;if(b>1){for(i=1;i<b;i++){printf("  %d\n",++a)}};a=$2}1' 1
    
16. 1 1006 + 0 2 CHH CCC U L L L L L
    
17. 1 1007 + 0 2 CHH CCT U L L L L L
    
18. 1 1008 + 0 2 CHH CTA U L L L L L
    
19.   1009
    
20.   1010
    
21.   1011
    
22.   1012
    
23. 1 1013 + 0 2 CHH CCC U L L L L L
    
24. 1 1014 + 0 2 CHH CCT U L L L L L
    
25. 1 1015 + 0 2 CHH CTA U L L L L L
    
26.   1016
    
27.   1017
    
28.   1018
    
29.   1019
    
30. 1 1020 + 0 2 CHH CCC U L L L L L
    
31. 1 1021 + 0 2 CHH CCT U L L L L L
    
32. 1 1022 + 0 2 CHH CTA U L L L L L
    
33.   1023
    
34.   1024
    
35.   1025
    
36.   1026
    
37. 1 1027 + 0 2 CHH CCC U L L L L L
    
38. 1 1028 + 0 2 CHH CCT U L L L L L
    
39. 1 1029 + 1 2 CHH CTA U L L L L U

复制代码

wh7211

回复 4# hechao7021

1. cat 1
   
2. 1 1006 + 0 2 CHH CCC U L L L L L
   
3. 1 1007 + 0 2 CHH CCT U L L L L L
   
4. 1 1008 + 0 2 CHH CTA U L L L L L
   
5. 1 1013 + 0 2 CHH CCC U L L L L L
   
6. 2 1005 + 0 2 CHH CCT U L L L L L
   
7. 2 1009 + 0 2 CHH CTA U L L L L L
   
8. 2 1010 + 0 2 CHH CCC U L L L L L
   
9. 2 1012 + 0 2 CHH CCT U L L L L L
   
10. 3 1002 + 0 2 CHH CTA U L L L L L
    
11. 3 1017 + 0 2 CHH CCC U L L L L L
    
12. 3 1018 + 0 2 CHH CCT U L L L L L
    
13. 3 1020 + 1 2 CHH CTA U L L L L U
    
14. 
    
15. awk '{b=a?$2-a:1;if(b>1){for(i=1;i<b;i++){printf("  %d\n",++a)}};a=$2}1' 1
    
16. 1 1006 + 0 2 CHH CCC U L L L L L
    
17. 1 1007 + 0 2 CHH CCT U L L L L L
    
18. 1 1008 + 0 2 CHH CTA U L L L L L
    
19.   1009
    
20.   1010
    
21.   1011
    
22.   1012
    
23. 1 1013 + 0 2 CHH CCC U L L L L L
    
24. 2 1005 + 0 2 CHH CCT U L L L L L
    
25.   1006
    
26.   1007
    
27.   1008
    
28. 2 1009 + 0 2 CHH CTA U L L L L L
    
29. 2 1010 + 0 2 CHH CCC U L L L L L
    
30.   1011
    
31. 2 1012 + 0 2 CHH CCT U L L L L L
    
32. 3 1002 + 0 2 CHH CTA U L L L L L
    
33.   1003
    
34.   1004
    
35.   1005
    
36.   1006
    
37.   1007
    
38.   1008
    
39.   1009
    
40.   1010
    
41.   1011
    
42.   1012
    
43.   1013
    
44.   1014
    
45.   1015
    
46.   1016
    
47. 3 1017 + 0 2 CHH CCC U L L L L L
    
48. 3 1018 + 0 2 CHH CCT U L L L L L
    
49.   1019
    
50. 3 1020 + 1 2 CHH CTA U L L L L U

复制代码

hechao7021

回复 6# wh7211
万分感谢，受教了

hechao7021

awk '{b=a?$2-a:1;if(b>1&&$1==tep){for(i=1;i<b;i++){printf("  %d\n",++a)}};a=$2;tep=$1}1' 1