if matching strings in file1 and file2, add column from file1 to file2

view full story

http://www.unix.com – I have very limited coding skills but I'm wondering if someone could help me with this. There are many threads about matching strings in two files, but I have no idea how to add a column from one file to another based on a matching string. I'm looking to match column1 in file1 to the number following the string "Gene_" in file2. If there's a match, I want to add column 2 from file1 as the first column in file2. file1 Code: 1    k48_101119 2    k48_103273 3    k48_103895 4    k48_108200 5    k48_11007 [...] file2 (not all line (HowTos)