I would like to extract all rows of file 1 that meet two conditions in another file (file 2)
1. condition: file1.column1 == file2.column1 (like a string)
2. condition: file1.column2 is > file2.column2 and < file2.column3 (like a min max range)
I can solve each condition alone but not both together. How to do this? Any help is appreciated.