Matching and combining two files
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 then just write the info from file1 to the combined output file. If the name
(example-Silvia Spoelstra) is in file2, but not in file1, then do not write it to the combined output file.
file1
Firstname,Surename,City
Aidan,Rielly,Derry
John,Doe,London
Jack,Daniles,Glasgow
Ivor,Engine,Cardif
file2
Firstname,Surname,Country,ISO
Jack,Daniels,Scotland,GB
John,Doe,England,UK
Ivor,Engine,Wales,UK
Silvia,Spoelstra,Germany,DE
Combined file
Firstname,Surename,City,Country,ISO
Aidan,Rielly,Derry
John,Doe,London,England,UK
Jack,Daniles,Glasgow,Scotland,GB
Ivor,Engine,Cardif,Wales,UK
thanks in advance
Pete
Last edited by p3t3r; 05-20-2008 at 08:04 AM..