Regex to fetch table data

Hi @prasath17 can u help in fetching project # with regex which is highlighted. Its a number with - in between so this is the only thing I could find. There is no space on either side of -. I have highlighted some

City of Yuma, Arizona
Capital Improvement Program
FY 2021 - FY 2025
PROJECTS & FUNDING SOURCES BY DEPARTMENT

Department Project # 2021 2022 2023 2024 2025 Total
Facilities Maintenance
Replace Boilers - Yuma Art Center 0450-BOIL 30,000 30,000
Two Percent Tax 30,000 30,000
Replace Carpet - City Hall 0450-CARP 50,000 50,000 50,000 50,000 200,000
General Fund 50,000 50,000 50,000 50,000 200,000
Replace Main Hall Ceiling Tiles & Painting 0450-CIVIC 32,000 32,000
Two Percent Tax 32,000 32,000
Reconfigure City Hall Front Door 0450-DOOR 85,000 85,000
General Fund 85,000 85,000
Replace Fire Panels - PD/MC 0450-FIRE 150,000 150,000
Public Safety Tax Fund 150,000 150,000
Security Bi-Fold Gate Repair - PD/MC 0450-GATE 72,000 72,000
Public Safety Tax Fund 72,000 72,000
Replace Air Handlers - PD/MC 0450-HVAC 665,000 665,000
Public Safety Tax Fund 665,000 665,000
Replace Fan Coils - PD/MC 0450-HVAC1 105,000 105,000
Public Safety Tax Fund 105,000 105,000
Replace A/C Units - Fire Station #5
Public Safety Tax Fund 0450-HVAC2 18,000 18,000
Replace A/C Units - City Hall 18,000 18,000
General Fund 0450-HVAC3 400,000 400,000
Replace A/C Units - Yuma Civic Center 400,000 400,000
0450-HVAC4 55,000 55,000
Two Percent Tax 55,000 55,000
Replace Chiller #3 - PD/MC 0450-HVAC5 350,000 350,000
Public Safety Tax Fund 350,000 350,000
Police Department/Municipal Court HVAC 0450-HVAC6 226,000 226,000
Public Safety Tax Fund 226,000 226,000
Paint City Hall 0450-PAINT 100,000 100,000
General Fund 100,000 100,000
Parking Lot Repair / Maintenance 0450-PARK1 285,000 285,000
General Fund 285,000 285,000
Replaster Pool - Valley Aquatics Center 0450-POOL1 30,000 30,000
Two Percent Tax 30,000 30,000
Recoat Flat Roof - PD/MC 0450-ROOF 27,500 27,500
Public Safety Tax Fund 27,500 27,500
Repair and Maintain the Public Safety Track 0450-TRAC 175,000 175,000
Public Safety Tax Fund 175,000 175,000
Facilities Maintenance Total 751,000 1,205,000 284,500 715,000 50,000 3,005,500
General Government
Citywide Development Fee Update 0083-GOVT3 100,000 100,000
Development Fee 100,000 100,000
Regional Fiber Optic Infrastructure Master Plan0083-GOVT4 55,000 55,000

FY 2021 - FY 2025 Capital Improvement Program Page 2 Effective July 1, 2020

@rameezimtiaz - Assuming the first 4 characters will always be the numbers…

\d{4}-\w+

They can be alphabets as well. Only thing that is for sure is a dash in between

okay…but is it always XXXX-XXXX or XXXX-XXXXX pattern?? if yes then try the below pattern…

\w{4}-\w{4,5}

@prasath17 this worked for me. Thanks for ur help :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.