I have a need to compare 2 csv files file a and file b .
create an output file c that is tab delimited. This file should just have the records in file b that do not match file a.
If the record is same in both file a and file b, and exactly same, I do not need it in c
If the record is in file a, not in file b, I do not need it in c
If the record is in file a and file b, and atleast one column has different value, write the complete record as is in file b to file c.
Id,username,Fname,Lname (this is a header line and should be present in all files)
In this case, Id#1 got dropped off in file b and also Id#4 got added. Also user3's last name changed. So the output should look like
Id username Fname Lname
3 user3 Joe Palker
4 user4 John Smith
Note that my original file has 11 columns and I will have to check for data changes in each and every one of them.