RegEx/Power Automate Desktop: Capture all data from specific string to last pattern occurrence?

I’m attempting to use RegEx with Power Automate Desktop to match patterns from a specific string to the last occurring pattern:

Example list:

00_000_A.B.C.\_One_Room
Schrute_Dwight
Halpert_Jim
Scott_Michael
00_000_A.B.C.\_One_Room
Schrute_Dwight
Halpert_Jim
Scott_Michael
01_200_A.B.C.\_Two_Room
Schrute_Dwight
Halpert_Jim
Scott_Michael

In this example list, I’d like to parse all data starting from 00_000_A.B.C._One_Room to the last occurring pattern of LAST_FIRST before 01_200_A.B.C._Two_Room. I’m parsing this data to write to Excel.

Is this possible? (And is this possible with Power Automate Desktop?)

I’m new to RegEx, and I’ve been fiddling around with something like this:

00_000_A.B.C._One_Room(([A-Za-z]`_`+`_`[A-Za-z]+|\n)*)

I’ve attached an image with the results I get with this. All the data I want is highlighted in that tester… but Power Automate doesn’t capture all of it – only one instance of the 00_000_A.B.C._One_Room.

enter image description here

Read more here: Source link