REGEX Statement - Parse Remove Data Between Params

[sslattery17]

Looking for assistance on this issue.  I am trying to build either a regex or other to remove rows between two key phrase_words "Future Resident Details" and "Rent Roll Valencedocs".

This data is at a different start row or record # for each property.  I have been using regex101 to help learn to build and test but I cant seem to get there. I am open to a different approach but have built my two part workflow.

Unit Type Column - has the same status as current tenants so that field cannot be used to filter out.

Unit # and Zero Rent - cannot filter out as not all rent on future tenants are zero $    

^\b(,+g)Future Resident Details{.+g}Rent Roll Valencedocs\w+$

Below is sample of data from Belmont; 3rd sheet:  When all the sheets are brought into the workflow; you get the data that is between the two parameters.  

Future Resident Details

Bldg-Unit Unit Type SQFT Unit Status Resident Move-In Lease Start Lease End Market Rent Ledger Charge Code Transaction ID Post Date Actual Charges Scheduled Charges Balance Deposit Held

032-032-03 JR3 420.00 Notice Rented Corey, James 5/1/2025 5/1/2025 4/30/2026 1,440.00 Resident Rent 0.00 1,440.00 0.00 1,440.00 

Charge Total: 0.00 1,440.00

Belmont West Total: 420.00 1,440.00 0.00 1,440.00 0.00 1,440.00 

Rent Roll Valencedocs

[griffinwelsh]

@sslattery17 See the attached sample solution. This will remove all rows that contain those two strings and any rows between those pairings. Let me know if you need further assistance or please mark the thread solved if this fits your needs.

[CSmith16]

@sslattery17 Can you clarify what you're asking for? Are you asking to filter out the Unit Details Table on the 

[sslattery17]

@griffinwelsh 

Thank you.  This solution does not work with my current workflow and I do not want to rebuild it.

@CSmith16 

I would prefer not to filter and join.

I am looking to remove all data between the two parameters.  I have tried to figure out a way to assign and replace the unit # for all tenants between Future Resident Details and Rent Roll Valencedocs.  Take a look at the multi-tab spreadsheet which I bring into the workflow; each one at the end has Future tenant information.  Sometimes these unit numbers are the same as current tenants all units above Future.

I know there is a way to do this just cant seem to get there.

[griffinwelsh]

@sslattery17 would you be able to provide your current workflow or an example expected input and output? This will make it much easier to build a solution that fits your current setup.

[sslattery17]

Attached workflow package

[CSmith16]

@sslattery17 

By far not the most elegant solution, and I'm not sure I quite understand if this is what you want still, but if it is take a look at this: