File Comparison
Hi i have 2 csv files a.csv and b.csv with the same number of columns and a list of values in both of it. Each and every individual value in both the files need to compared and if it matches then print correct in a new csv file otherwise print Incorrect
eg
a.csv
1,12/27/2007,Reward,$10.00
2,12/27/2007,Reward,$20.00
3,12/27/2007,Reward,$30.00
4,12/27/2007,Commission,$40.00
5,12/28/2007,Reward,$10.00
6,12/27/2007,Reward,$20.00
7,12/27/2007,Reward $30.00
b.csv
1,12/27/2007,Reward,$10.00
2,12/27/2007,Reward,$20.00
3,12/27/2007,Reward,$30.00
4,12/27/2007,Reward,$40.00
5,12/28/2007,Reward,$10.00
6,12/27/2007,Reward,$20.00
7,12/27/2007,Reward $30.00
After comparing these two csv files the final comparison csv file should look like this
Correct,Correct,Correct,Correct
Correct,Correct,Correct,Correct
Correct,Correct,Correct,Correct
Correct,Correct,Incorrect,Correct
Correct,Correct,Correct,Correct
Correct,Correct,Correct,Correct
Correct,Correct,Correct,Correct
Im new to Shell script and awk programming. Suggest me acode with explanation for this requirement in either awk programming or shell scripting.
Please do make it soon its very urgent
Looking forward for your quick response
Regards,
Naveen