awk code error for removing duplicate records between 2 files 1

[Coop197823]

I found this bit of awk code that compares the first column of two files and then deletes the duplicate records of the second file.

 awk 'FNR==NR{a[$1];next};!($1 in a)' file1 file2 > file3

When I run the code, I get an error that says: ^ invalid char ''' in expression

I am very new to awk coding, so I do not too sure what is causing the error. Any help would be greatly appreciated! Thanks in advance!

 

[feherke]

Hi

Based on the error message I suppose you are running it on Windows. In that case you could
[ul]
[li]Run it in Cygwin's terminal. There you will benefit of all the Linux shell features, including the possibility to use single quotes ( ' ) as string delimiters.[/li]
[li]Replace single quote ( ' ) with double quotes ( " ). Not sure, but maybe for this extremely simple code will work.[/li]
[li]Put all code in a file and pass that to the interpreter :

[navy]FNR[/navy][teal]==[/teal]NR[teal]{[/teal]a[teal][[/teal][navy]$1[/navy][teal]];[/teal][b]next[/b][teal]};!([/teal][navy]$1[/navy] [b]in[/b] a[teal])[/teal]

awk -f nodup.awk file1 file2 > file3

[/li]
[/ul]

If not, then you will have to give us more details about system, shell and Awk implementation and version.

Feherke.
feherke.ga

 

[Coop197823]

Yep that worked, Thank you!!