Shell Programming and Scripting

Hi,

I'm trying to find the nearest match between two columns of numbers, e.g.

1,1
10,8
30,50
20,100

and the search could be e.g. 20,20

returning 10,8 - i.e. 20-10 = 10 and 20-8 = 12 totalling 22, and hence being the nearest match.

any ideas?

thanks a lot,

>is it possible, with perl, to find the closest numerical value to a set value.
>>IE. a set of va;lues in column1 (a set value of 15) and I have another column with some set of values (five values, 208,258,56,123 )
>>
>I made perl script too go through the five values array to find the closest to
>>15 .
Iwant to assign this to column1 column 2 with thousands of values. Is it possible to assign this same script to col1 and col2?????

use strict;
> use warnings;
>
> my $set = 15;
> my @vals = (208, 258, 56, 123);
>
> print closest($set, @vals), "\n";
>
> sub closest {
> my $val = shift;
> my @list = sort { abs($a - $val) <=> abs($b - $val) } @_;
> $list[0];
> }
>

thanx alot in advance

Hi bogu,

I´m not sure, I think you want the value in column1 that is the most similar or nearest from every value in column 2.

Well, I´m thinking about an algorithm that could work assuming the values in both columns are in ascending order.

Experts, may somebody correct me?. I´m new with awk, I´ve only got so far the code showed below, which it´s not working yet.
I hope the logic makes sense

Code:

awk '{a[i]=$1;b[i]=$2;next} 
{ for (j=1;j<=i;j++) 
		{ 
			if(a[j]<=b[j] && b[j]>=a[j+1]) {$3==a[i]; print;break}
		}
}' Inputfile

My idea in this code is to find out where the value "i" of column 2 is between 2 consecutive values in column 1, and then copy in column 3 the first value of those 2 consecutive values.

Thanks for any cooperation

thanx alot for the co operation . lets hope for the perfect answer from some experts.

Hi guys
I have 2 files with different numbers. I would like to join the nearest possible values. for example

File 1

3000000
100000000
110000000
120000000

File 2

2908791
115194157
114942245
114942510
9830920
86792476
116181989
173550955
82609186
100487233

out put

2908791 3000000
115194157 110000000

some thiiig like that

Thanx alot in advance

file 1
150
350


file 2

100
200
300
400
500

output
150 200
350 400

In editing – awk script -Not working

My idea in this code is to find out where the value "i" of column 2 is between 2 consecutive values in column 1, and then copy in column 3 the first value of those 2 consecutive values.

awk '{a[i]=$1;b[i]=$2;next}
{ for (j=1;j<=i;j++)
{
if(a[j]<=b[j] && b[j]>=a[j+1]) {$3==a[i]; print;break}
}
}' Inputfile