Shell Programming and Scripting

Hi,

I need to compare a column in two different csv files

file1
xyz.com,2/2/12,a,b,c
eg.com,2/2/23,a,b,ga

file2
1,2,ua,xyz.com
1,2,ua,abc.com
1,2,ua,eg.com
1,2,ua,easg.com
1,2,ua,zth.com

Read all entries in file1(which has 1000+) and compare column1 of file1 with the column4 of file2 and if matches dont print in file3.

File3 should have only the unmatched columns of above condition.

Thanks.

There're other similar threads in these forums - use the 'Search' function in the future.

Code:

nawk -F, 'FNR==NR {f2[$4]; next} !($1 in f2)' OFS=',' file2 file1 > file3

It worked.

Thank you!

hmm I spoke early, actuall it did not work.

Since the files are huge and I randomly checked and thought it worked.

But I placed a sample value in file1 and file2 and the result file still has that value.

File 1
laeg.com,2/2/23,a,b,ga
aeg.com,2/2/23,a,b,ga
xyz.com,2/2/12,a,b,c
eg.com,2/2/23,a,b,ga

File 2
1,2,ua,xyz.com
1,2,ua,abc.com
1,2,ua,eg.com
1,2,ua,easg.com
1,2,ua,zth.com

File 3
laeg.com,2/2/23,a,b,ga
aeg.com,2/2/23,a,b,ga
xyz.com,2/2/12,a,b,c
eg.com,2/2/23,a,b,ga

Check the xyz.com, its in 3rd row in file1 and and 1st row in file2 and also apprears in 3 rd in file 3.

My be i didnot explain my requirement, when read in file1 it should compare in each row on file2 if found any where in the file2 it should be ignored while writing file1.

Try this:

Code:

awk -F, '{ print $1 }' file1 >temp
grep -vf temp file2

Not working.

grep -vf temp file2 just hangs