UNIX for Dummies Questions & Answers

I'm new to scripting and would appreciate any help.

I have a list of over 20 words in File1 that I need to find in columns 10-15 of File2. I need the entire row of File2 that the File1 list matches.

I originally used a grep command which works, but provides File1 results that can be found anywhere in a line. Again, I need only results that fall in column 10-15 but need the entire row in the final results. I think this is an awk solve, but I am not sure. I don't think grep can search specific columns, only lines, and there is nothing that I have found to support it.

Small scaled example: grep -fFile1 File2 > File3

#File1
25544
31140
22253
12460

#File2
1 25544 65406456 65406540 65406540
1 16487 65406456 25544540 65406540
1 31140 65406456 65406540 65406540
1 22253 65406456 65406540 65406540
1 35111 31140456 65406540 65406540
1 12460 65406456 65406540 65406540
1 98798 65406456 165140540 65406540

#FILE3 <my results>
1 25544 65406456 65406540 65406540
1 16487 65406456 25544540 65406540 ---Don't want this line but get a return because 25544 is in the line but not desired column
1 31140 65406456 65406540 65406540
1 22253 65406456 65406540 65406540
1 35111 31140456 65406540 65406540 ---Don't want this line but get a return because 31140 is in the line but not desired column
1 12460 65406456 65406540 65406540


Any help is greatly appreciated.

Based on your example, this will do what you want but i didn't understand what you mean by column 10-15

Code:

awk 'NR==FNR{arr[$1];next}$2 in arr{print}' file1 file2

Sorry if I am not asking the question the right way or I confuse you. Thank you for the help, I will try this when I go in to work next.
By column 10-15 I mean that I only need file1 words that are found between columns 10-15 on any given line.
Column
12345678901234567890
_________025544
So 25544 must be here (between 10-15) and nowhere else. Unfortately if the number shows up in column 32-37 it will return a result and I don't want that.
These are satellite positions in two line element sets (TLE) which consists of all numbers, so essentially it is very possible to get File1 words anywhere in a File2.
I can't check this until Monday, will this solution still work?

Hi
Have you testred Malcomex's code? Here i tested it for you, and it looked good to me,result:

Code:

nawk 'NR==FNR{arr[$1];next}$2 in arr{print}' f1.txt  f2.txt 
1 25544 65406456 65406540 65406540
1 31140 65406456 65406540 65406540
1 22253 65406456 65406540 65406540
1 12460 65406456 65406540 65406540