Reply
MartinDra
Frequent Visitor
Partially syndicated - Outbound

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

MartinDra_0-1675960606273.png

 

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 

MartinDra_1-1675960703309.png

 

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. 

 

 

 

0 REPLIES 0
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)