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
