Extracting data from text/log file
Having a little difficulty...and was hoping to be pointed in the right direction
I have a huge amdas log file with lots of data - several thousand rows
I am looking to parse two lines so i could do a comparison between the timestamp
The beginning line is
INFO : 2020-11-06 13:58:54.814: (thread: 1333782272): ==> Received payload from Postfix
The ending line is
INFO : 2020-11-06 13:58:55.449: (thread: 1333782272): ==> TRANSACTION completed.
There are several lines in-between - the unique values are "Received payload from Postfix" and "TRANSACTION completed" …
and there will be several received/competed per log file
Where I am attempting to get the Received time stamp into column A and completed time stamp to column B..
I can import the file, not problem but having issues with the values, and help is appreciated... My macro skill are rusty..
sample log files attached
6.5 KB Views: 3