My system gets data in flat file for booking.Once the booking is completed , customer sends some corrections data in other flat file. I have to compare both flat files data in window based comparison tool like EXamdiff Pro . if sent correction notes is ok, then update the physical files.
example Original flat file 1 :
HDRINTT BKGS300 E2011020711 ID PCABBDL00 PNACHIW RFGTUSOAK0222516 RFINUSOAK0222516 RFBKPCABBDL00
received revised flat file : HDRINTT BKGS300 E2011020711 ID PCABBDL00 SNACHIW RFGTUSOAK0222516 RFINUSOAK0222516 RFBKPCABBDL00
so SNACHIW is new value at ID level . PNACHIW shud be updated with SNACHIW.
differences shud be highlighed in Comparison tool so that use can ignore and update changes.
Plz suggest the way to proceed. My system gets data in flat file