10 10xxxCHANGEDATE02/08/200201/08/2002 8 8xxxCHANGETIME16:56:4814:56:45 2 2xxxCHANGEINITLFMA 5 5xxxCHANGENUM 48 47 0 1xxxCHK17 X 0 2xxxCHK17INIT LF 0 10xxxCHK17DATE 18/07/2002 0 8xxxCHK17TIME 14:09:31 15 15xxxLASTEDIT1 PDM1 821430PDM1 817305 15 15xxxLASTEDIT2 PDM1 817305PDM1 816340I would like to read this into a grid 3 columns. So that the format would be shown for the above like:
Fieldname Old Data New Data CHANGEDATE 14:56:45 16:56:48 CHANGEINIT MA LF CHANGENUM 47 48 CHK17 0 X etc etcAs you can see from the contents of the file after every field type CHANGEDATE or CHANGEINIT the new data is next to it and the old one is the next value.