Search Results

works perfectly with nawk. :D

Thankyou very much
Pete

Hi, thanks for the quick response. I get a syntax error when I try this.

$ awk -F, '
> BEGIN{print "Firstname,Surename,City,Country,ISO"}
> NR==FNR{a[$1$2]=$3","$4;next}
> a[$1$2]{print $0...

Hi, How can I match the first two fields of file2 against the first two fields of file1 and where they match combine the two lines. If the name
(example-Aidan Rielly) is in file1 but not in file2...