Shell Programming and Scripting

I have attached an printscreen of the output:


rs-nr.txt is file 2 with the rs numbers only. Geno.csv is the total file.


Much appreciated!

Please post the output of

Code:

head -2 Geno.csv|od -bc

Here it is:

OK. It seems that file2 has some white-space before and/or after the data. Try this:

Code:

awk 'FNR==NR{a[toupper($1)]=1;next}(FNR!=1 && ($3 in a))||FNR==1' file2 file1

Unfortunately it still results in the header of file 1 only.
Might the fact the file 1 is tab delimited play a role?


Much appreciated!

try using gsub on $0 of file2

Tried a replace of tabs to spaces. Unfortunately to no avail.

Talked to the owner of the file. It was DOS formatted and I forgot to check .

I did a

Code:

tr -d "\r"

on the file and then ran your code again. Lo-and-behold: it finally works!

Thanks a lot for your help. The line endings were my won stupid mistake, but the awk command I could not have dreamt.

As a final question, for me to learn, could you please give me a quick run-through of the command? A quick explantion is usually clearer than a trip through the MAN pages.

Thanks again.