Hi

I have 2 files

file1

12312341231612634
34534368463786347
23472364287687263
23472357841007237

file2

12123561235176351*dhfsdhfh*2347623462*sdfjshehweu*123651235*sdgfsgfsy*23237346*
23472357841007237*defsjdf*12378234*hsdhfsdhgfsh*12837238947*dsjshgdfs*2348972348*
12312376234237868*fvdfvd*2342783239487*sdfsjefhsd*27236*sdhfsdhfs*2347234*

I want to use join in get those records that are present in file1 from file2 and want the complete line.

I dont want to use grep since the file size is high and it would take a long time to search for each record.

I am using Join

join -j1 1 -j2 1 file1 file2 -o ("I want complete row") cannot use 2.1 2.2 2.3 and so on as there are more than 100 fields.

Please suggest a solution.