- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 08-09-2024 04:12 AM | ||
01-19-2024 05:33 AM | |||
04-08-2024 01:01 AM | |||
12-07-2023 01:46 PM | |||
02-04-2024 05:18 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |