UNIX for Dummies Questions & Answers

Hi vgersh99, I tried yours but it said:

-bash: nawk: command not found

Thanks 2pugs...I keep getting errors though

try either awk or gawk (instead of nawk).

awk works, is there any difference between nawk and awk?

the output is off, it is showing this:

Code:

29    chr1    59497    59498    snp    T    C    dbsnp.100:rs2854666;
chr1    61442    A    G 3

for example... the chr 1 looks to be lining up but not the 4th and 2nd columns.

Moderator's Comments:

Please use code tags when posting data and code samples!

the implementation is based on your original description of the key fields:
The sample files you provided don't have matching records based on your description. So either the description is wrong or the provided sample files are not representative.
Provide either a better description OR a more representative data files (using code tags).

Also provide a desired result based on the sample data files: either WITH the matching records OR withOUT one - we can only guess what the OP's intent might be...

Sorry vgersh99 - it does work - thank you so very much.

The reason I was confused is because all the rows from column two are still in this file, but I can just awk for the rows I need.

Much appreciated.

Had you given a desired output, we could have achieved it in one 'go'.....