Compare two CSV files
Hi,
I have to compare two .csv files and get the output in other file in the given format.
First column in provided files would be unique.
If a new line is added I want A followed by "," and then followed by entire new row.
If a line is modified I want C followed by "," and then followed by entire modified row.
If a line is deleted I want D followed by "," and then followed by entire deleted row.
File 1
aa, bb, cc, dd, ee
bb, ww, ee, tt, yy
cc, vv, vv, vv, vv
File 2
bb, ww, ee, tt, y1
cc, vv, vv, vv, vv
nn, bb, nn, cc, bb
So output be like
D, aa, bb, cc, dd, ee
C, bb, ww, ee, tt, y1
A, nn, bb, nn, cc, bb