Forum Discussion

MartinDra's avatar
MartinDra
Frequent Visitor
3 years ago

How to extract data between 2 text rows

Hi, 

 

I am working with a log text file and I am having issues cleaning it up to provide meaningful data.

I am looking to put in seperate columns data between 2 events.

 

New entry always starts with text "Processing"

and entry ends with "Processed"

 

all rows inbetween are descriptions of what is happening between those 2 events.

 

example below

 

what I want is a report that will flag all items where "Pivot?" = 5

and details of the event around from that message.

 

I.e

all of this 

 

I have tried pivot but becasue multiple events can occur at the same time as well as some events span across multiple minutes then I am getting errors of multiple items in one cell. 

 

I had a version where I was able to flag errors that occured during the day but unable to get all information, only exact match to a time. 

 

 

 

No RepliesBe the first to reply