{getline< "file1";ln[NR]=$1; lt[NR]=$2}

var1 =$1
var2 =$2
calc1= $2-0.1
calc2=$2+0.1
x=0
y=0

for(j=1;j<=file2's length,j++)

(i=1;i<file1's array length;i++)

if lt[i] >=calc1 && lt[i]<=calc2

c=`awk 'END{print NR}'file1`
awk '{{getline< "file1";ln[NR]=$1; lt[NR]=$2}}
FNR<=NR{
l1=$1;
la1=$2;
p=la1+0.1;
m=la1-0.1;
x=0;
y=0;
{
for(j=1;j<='$c';j++)
if(lt[j]>=m && lt[j]<=p)
{
if(l1>=ln[j])
x=x+1
if(l1<=ln[j])
y=y+1
}
}
if(x>=1 && y>=1)
print l1,la1,"Wow you are safe..."
}' OFS="\t" file2.dat

c=`awk 'END{print NR}' file1.txt`
awk '{{getline< "file1.txt";ll[NR]=$1;lt[NR]=$2}}
FNR<=NR{
ll1=$1
lt1=$2
p=$2+0.1
m=$2-0.1
x=0
y=0
ct=ct+1
cc=$3
{
for(j=1;j<='$c';j++)
if(lt[j]>=m && lt[j]<=p)
{
if(ll1>=ll[j])
{x=x+1}
if(ll1<=ll[j])
{y=y+1}
}
}
if(x>=1 && y>=1)
{print ll1,lt1,"You are in"}
}' OFS="\t" file2.txt

68.14    23.48    You are in
67.62    23.04    You are in   ------->wrong 23.04 not exist in file2
67.68    23.09    You are in   -------> file1 data is printing
67.73    23.14    You are in   -------> again wrong result...
67.79    23.19    You are in
67.85    23.24    You are in
67.91    23.28    You are in
67.97    23.33    You are in
68.02    23.38    You are in
68.08    23.43    You are in
67.56    22.99    You are in
67.13    22.54    You are in

Attached Files

	file1.txt (38.2 KB, 1 views)
	file2.txt (2.1 KB, 1 views)

Quote:

Originally Posted by Akshay Hegde Code: I just want to use this logic in shell awk script 1 . First read column 1 and column 2 of file1.txt store it in array(reference) 2 . Now read column 1 and column 2 of file2.txt store it in another array,to be compared with reference 3 . for loop : - for(i=1;i<=file2.txt_length;i++) 4 . x=0; y=0 this will get clear as and when i will increment 5 . nested loop :- for(j=1;j<=file1.txt_lenght;j++) 6 . if(col1_f1[j]>=col1_f2-0.1[i] && col1_f1[j]<=col1_f2+0.1[i]) if above if statement is true then,go to following statement else check condition with j++ 7 . if(col2_f2[i]>=col2_f1[j]) then x=x+1 8 . if(col2_f2[i]<=col2_f1[j]) then y=y+1 repeat 5,6,7 and 8 till j reaches file1.txt_length(NR),Once j reaches NR following 9 . if(x>=1 && y>=1) then print column1_f2[i] column2_f2[i] repeat statements after number 4 to 9 till i reaches file2.txt_length(NR) I hope this will be helpful this logic is to find whether file 2.txt is falling within the range of file1.txt(reference) if falling, how many records are near to records of file1.txt and this is for mapping purpose, one can see script's result preview in GMT, with reference file I am trying to write the same logic in awk script, but I couldn't succeed..those who know...awk very well pls help Thanks in advance.........................

Even with all of your color coding, this logic isn't clear to me. But, just looking at the 1st and last line of your 2nd awk script:

Code:

awk '{{getline< "file1.txt";ll[NR]=$1;lt[NR]=$2}}
}' OFS="\t" file2.txt

awk '
FNR == NR {
        # Save a line from the 1st input file...
        col1_f1[++f1c] = $1
        col2_f1[f1c] = $2
        next
}
{       # Save a line from the 2nd input file...
        col1_f2[++f2c] = $1
        col2_f2[f2c] = $2
}
END {   # Do whatever processing you want to do with the f1c lines you have
        # read into col1_f1[] and col2_f1[] and with the f2c lines you have
        # read into col1_f2[] and col2_f2[].
        # ... ... ...
        printf("%d lines in 1st input file, %d lines in 2nd file.\n", f1c, f2c)
}' file1.txt file2.txt