Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
MartinDra
Frequent Visitor

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.