I have a log file that contains thousands of lines of data.
My intention is to import it into Excel and examine the data, and perform two different checks.
Is there a macro or can one be create to check each record date and assure each records time interval are all the same and the sequence also.
Check 1: Assure each record are 2 minutes apart or the number of seconds user assigned each record to be.
For instance, Each record should be 2 minutes (120 seconds) aparts.
Record Number = 1,1/1/2012 2:00:00 PM
Record Number = 2,1/1/2012 2:02:00 PM
Record Number = 3,1/1/2012 2:04:00 PM
Record Number = 4,1/1/2012 2:06:00 PM
In the log, the column for Sensor Blinks should all be in sequential order.
Flag each line skip. For instance the following example below, Sensor Blink 5 was skipped, so it needs to be reported.
Sensor Blinks = 1,
Sensor Blinks = 2,
Sensor Blinks = 3,
Sensor Blinks = 4,
Sensor Blinks = 6,
Sensor Blinks = 7,