|
merge file with nearest range !!!!!!!
I want join 2 files with range of numbers in ascending order according to the value of the numbers the input will be like this
INPUT
file1
column1 column2
10 14
20 25
56 58
83 90
FILE 2
column1 column 2
1 2
2 8
10 14
20 24
50 58
60 63
70 76
80 100
OUTPUT
col1 col2 col3 col4
1 2
2 8
10 14 10 14
20 25 20 24
56 58 50 58
70 76
83 90 80 100
|