Hi All, I am new to awk, and having a hard time trying things myself, hope you can help me out. I have file A with two columns, it looks like this:

7000000185249034 1114

7000000185249048 1532690

7000000185249052 755361

7000000185249068 427550

7000000185249070 269102

7000000185249081 291122

And I have file B with three columns, it looks like this:

7000000185249100 1622651 1623044

7000000185249048 235104 235805

7000000185249146 2500324 2502635

7000000185249100 1218818 1221734

7000000185249468 88587 89699

7000000185249239 299691 300277

7000000185249315 769635 769986

7000000185249374 1548986 1549747

So what I wanted to do is to print out lines from file A, if the number in first column in file A matches the number in first column in file B, and the number in the second column in file A is within the range of the numbers in the second and third columns in file B.

I tried with the following code, but failed. awk -F '\t' 'FNR==NR{a[$1,$2,$3]=$0;next}{if(b=a[$1, >=$2 && <= $3]){print b}}' file B file A

Any advice will be appreciated! Thank you in advance!