UNIX for Dummies Questions & Answers

Hi,

I am a newbie in unix programming so maybe this is a simple question.
I would like to know how can I make a script that outputs only the values that are not between any given start and end positions

Example

file1:
2 30
40 80
82 100

file2:
ID1 1
ID2 35
ID3 80
ID4 81
ID6 160

So, I would like to save to a file the lines from file2 where the numbers from column two are not between the start and end position of file1. Therefore, the desired output would be:

Desired output file:
ID4 81
ID6 160

Thanks in advance.

Trying to figure out if better to create an intermediate file, or setup with arrays of the data of your first file.
How big could the numbers get? Your example has a maximum value of 160.

Hi,

Thanks for the reply. My files are big (about 355000 lines each), and the maximum value is 161000000.

How many conditions (entries) in that first file would there be?
[Your example has only three]

How many records do you anticipate in this would be included in your first file?
[Your example has three ranges, and they are 29 recs + 41 recs + 39 recs = 109 recs]

There would be 355968 entries in the first file and 178845 in the second one.
The ranges of each entry in the first file are always 36.

Best regards

But, are they also multiples of 36?

(Lots of data to read/process and to validate against.)

No, they are not always multiples of 36.