UNIX for Dummies Questions & Answers

Trying to do some simple maths on a large file. Excel works fine but I have 1 million entries:

If the difference between a number in column 2 and the one above it is more than 100 the insert a new line

8 4001 4100
8 4101 4200
8 4201 4300
8 15901 16000
8 15910 16100

For column 2
if 4101-4001 is > than 100 then insert a new line
else 'move onto next number'
end if
exit loop

The result for the example given should be:
8 4001 4100
8 4101 4200
8 4201 4300

8 15901 16000
8 15910 16100

Thanks for any help

L

Code:

$ cat file
8 4001 4100
8 4101 4200
8 4201 4300
8 15901 16000
8 15910 16100
8 16910 16100

Code:

awk '$2-s > 100 && s {print RS $0; s=$2; next} s=$2' file

Output:

Code:

8 4001 4100
8 4101 4200
8 4201 4300

8 15901 16000
8 15910 16100

8 16910 16100