I have two files, one file (file1.csv) contains a single column with 1200 values, 11-digits long, For instance: 00000001111 00000001152 etc.
Another file (file2.csv) contains 8 columns and consists of several tabs, in the third column there are the values that can also be found in 'file1.csv'. If there is an overlapping value I would like to print the entire row and put this into a new file (file3, or output.csv). Can someone help me with writing a script or a single command to solve this problem?
I tried google, to look if someone had a similar problem, I found this bash script which was kind of close to my problem so I gave ChatGPT this as a template. But, ChatGPT is not helping at all. Please, I come seeking guidance, can someone help me out? I have been trying stuff for several days but yeah not making any progress.