Help with a AWK function

Question

I have problems with AWK command. When I used this code is:

$ awk '{a[NR]=$1} 
 END {for (i=0;i<NR;i++)  
      {B=a[i+1];A=a[i];C=(B-A);D=int(C/16)} 
      {for (j=0;j<=D;j++) 
         {if(C!=16) {print t=A;A=A+16;B} else {print A}}
 }}' 19.txt

My input file "19.txt" is :

I got this out:

My code only use the difference of the last lines, why?? I want to complete the spaces between consecutive lines, where the different between lines is equal to 16, similar to this:

glenn jackman · Accepted Answer · 2015-07-30 16:30:58Z

3

This produces the output you're looking for, and it does not have to store the whole file in memory.

awk -v diff=16 ' 
    NR>1 && $1-prev > diff { 
        print "----" 
        while ($1-prev > diff) { 
            prev += diff 
            print prev 
        } 
        print "----" 
    }  
    { 
        print 
        prev = $1 
    } 
' 19.txt

Ask me if there's anything in there you don't understand.

answered Jul 30, 2015 at 16:30

glenn jackman

88.6k16 gold badges124 silver badges179 bronze badges

thank you for your answer, but it's not exactly I want. I don't need print "---" only the sum of16 to each line, like this: 1558 + 16=1574 (print 1574); 1574 +16=1590 (print 1590); 1590+16=1606...so on, until the $1 is less that prev, like 1606 < 1614 (print 1614) and continue...(1630-1614)=16 (print 1614); (1646-1630)=16 (then print 1630 ); (1702-1646)=56, 56 different to 16, then print (1646; 1646+16=1662;1662+16=78;....)

ELizabeth VIlcañaupa Raymundo
– ELizabeth VIlcañaupa Raymundo

2015-07-30 17:17:41 +00:00
Commented Jul 30, 2015 at 17:17
So, just remove the two print "----" lines

glenn jackman
– glenn jackman

2015-07-30 18:18:49 +00:00
Commented Jul 30, 2015 at 18:18
I'd like to offer a little script shorting awk -v diff=16 ' prev && $1 > prev { print "----" ; while ($1 > prev) { print prev ; prev += diff } ; print "----" } { print ; prev = $1 + diff } '

Costas
– Costas

2015-07-30 19:06:29 +00:00
Commented Jul 30, 2015 at 19:06

Add a comment |

Stack Exchange Network

Help with a AWK function

1 Answer 1

You must log in to answer this question.

Hot Network Questions

Help with a AWK function

1 Answer 1

You must log in to answer this question.

Related

Hot Network Questions