Search Results

Perhaps, you can run the opposite to diagnose the problem:
awk -F ',' 'FNR==NR {zip[$1]; next} !($2 in zip)' file2 file1
That will show the lines that did not make it, from file1. After that, you...

If you're trying to match on both of the fields that are present in file2, you might want to try something more like:
awk -F ',' 'FNR==NR {zip_parent[$1,$2]; next} ($2,$4) in zip_parent' file2 file1...

Hi, dan139

It would be much helpful if you were to give a few more lines from file1 and file2, in that way we can see what's the real structure of the files, which it will make a difference. Also,...