I really need your help Guys, I am new here in Unix. I want to compare my File2(3 column) to my File1(raw data), and save the result in a new file. But my files have a different delimiter.
File1 (in tab delimited) Col1 Col2 Col3 Col4 Col5 a 1 JJ KK DD b 2 TT RR EE c 3 QQ ZZ PP File2 (in pipe delimited) Col1 Col2 Col3 b TT RR c QQ ZZ Result Col1 Col2 Col3 Col4 Col5 b 2 TT RR EE c 3 QQ ZZ PP
Note that my files are large, I need a code that execute fast. And I need to match the 3 column of my file2 to be match on the file1. Thanks a lot!