#include <StringConstants.au3> ; to declare the Constants of StringRegExp
#include <Array.au3> ; UDF needed for _ArrayDisplay and _ArrayConcatenate
Local $sRegex = "(?m)(?<Catergory>.+[A-z]{2}\d{4})\s+(?<FY1>[\d.,-]+(?=\s))\s*(?<FY2>[\d.,-]+(?=\s))\s*(?<FY3>[\d.,-]+(?=\s))\s*(?<FY4>[\d.,-]+(?=\s))\s*(?<FY5>[\d.,-]+)\s*(?<FY6>[\d.,-]+)\s*(?<FY7>[\d.,-]+)\s*(?<FY8>[\d.,-]+)\s*(?<FY9>[\d.,-]+)"
Local $sString = "Return to Contents" & @CRLF & _
"" & @CRLF & _
"Streets Improvement Summary" & @CRLF & _
"" & @CRLF & _
"Capital Expenses (1,000s) Total Prior Years FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Years 6-10 Beyond 10" & @CRLF & _
"Yrs" & @CRLF & _
"" & @CRLF & _
"Ocotillo Road - Greenfield to Higley ST0540 66,519 332 12,413 53,774 - - - - -" & @CRLF & _
"" & @CRLF & _
"Baseline Road - Burk to Consolidated Canal ST0710 1,340 87 1,253 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Baseline Road - Greenfield to Power ST0780 8,801 112 - - - - 8,689 - -" & @CRLF & _
"" & @CRLF & _
"Recker Road - Ocotillo to Chandler Heights ST0800 11,611 - - - - - - 11,611 -" & @CRLF & _
"" & @CRLF & _
"Hunt Highway - Val Vista to 164th ST0840 86,241 40 - - - - - - 86,201" & @CRLF & _
"" & @CRLF & _
"Recker Road - Ray to SR 202 ST0960 3,940 455 3,485 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Higley Road - Riggs to Stacey ST0980 20,403 1,973 - - - - - 18,430 -" & @CRLF & _
"" & @CRLF & _
"Ocotillo Road - 148th to Greenfield ST0990 20,317 - 5,568 14,749 - - - - -" & @CRLF & _
"" & @CRLF & _
"Elliot Road - Neely to Burk ST1050 4,060 - - - - - - - 4,060" & @CRLF & _
"" & @CRLF & _
"Val Vista Drive - Appleby to Riggs ST1120 34,277 7,513 26,764 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Lindsay Road - Queen Creek to Ocotillo ST1140 3,881 171 1,097 2,613 - - - - -" & @CRLF & _
"" & @CRLF & _
"Hunt Highway - Higley to Recker ST1150 9,438 - - - - - - 9,438 -" & @CRLF & _
"" & @CRLF & _
"Recker Road - Riggs to Hunt Highway ST1160 11,395 104 - - - - - 11,291 -" & @CRLF & _
"" & @CRLF & _
"Lindsay Road - Pecos to SR 202 ST1170 12,171 6,609 5,562 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Warner Road - Power to East of Recker ST1180 14,752 - - - 14,752 - - - -" & @CRLF & _
"" & @CRLF & _
"Power Road - Guadalupe to Santan Freeway ST1200 15,140 - - - 15,140 - - - -" & @CRLF & _
"" & @CRLF & _
"Val Vista Drive - Riggs to Hunt Highway ST1270 7,779 - - - - - - 7,779 -" & @CRLF & _
"" & @CRLF & _
"Warner and Greenfield Intersection ST1300 12,367 - - - - - - - 12,367" & @CRLF & _
"" & @CRLF & _
"Ray and Gilbert Intersection ST1310 8,536 - - - - - - 8,536 -" & @CRLF & _
"" & @CRLF & _
"Elliot and Gilbert Intersection ST1320 8,626 66 - - - - 8,560 - -" & @CRLF & _
"" & @CRLF & _
"Guadalupe and Val Vista Intersection ST1330 8,880 - - - - - - 8,880 -" & @CRLF & _
"" & @CRLF & _
"Guadalupe and Power Intersection ST1340 8,790 - - 8,790 - - - - -" & @CRLF & _
"" & @CRLF & _
"Elliot and Cooper Intersection ST1380 10,370 670 9,700 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Elliot and Higley Intersection ST1390 7,552 - - - - - - 7,552 -" & @CRLF & _
"" & @CRLF & _
"Germann Road - Gilbert to Val Vista ST1450 27,429 4,385 23,044 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Turn Lane Safety and Congestion Improvements ST1540 9,329 723 1,170 1,104 1,583 1,583 1,583 1,583 -" & @CRLF & _
"" & @CRLF & _
"Accessibility Upgrades in Public ROW ST1550 2,209 1,278 586 345 - - - - -" & @CRLF & _
"" & @CRLF & _
"Constellation Way - South of Coldwater ST1570 3,356 55 - - - - - 3,301 -" & @CRLF & _
"" & @CRLF & _
"Lindsay Road/SR 202 Traffic Interchange ST1580 18,151 7,658 10,493 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Higley and Pecos Intersection ST1590 928 - - 928 - - - - -" & @CRLF & _
"" & @CRLF & _
"Infrastructure Imp at Railroad Crossings ST1600 2,545 57 2,488 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Mesquite Street - Lindsay to Val Vista ST1620 6,107 - - - 6,107 - - - -" & @CRLF & _
"" & @CRLF & _
"Adora Trails Improvements ST1660 874 830 44 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Val Vista Drive Reconstruction ST1690 7,405 491 6,914 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Val Vista Drive - Eastern Canal Bridge Repair ST1710 1,055 150 905 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Val Vista Lakes Improvements ST1720 48,195 480 64 12,147 8,860 10,276 16,368 - -" & @CRLF & _
"" & @CRLF & _
"Higley and Baseline Intersection ST1740 5,028 4,714 314 - - - - - -" & @CRLF & _
"" & @CRLF & _
"Guadalupe Road Improvements ST1770 9,920 - 1,750 8,170 - - - - -" & @CRLF & _
"" & @CRLF & _
"PM10 Paving ST1790 3,283 131 52 1,512 - - - 1,588 -" & @CRLF & _
"" & @CRLF & _
"Cooper Road - Encinas to Baseline ST1800 7,743 - - 7,743 - - - - -" & @CRLF & _
"" & @CRLF & _
"Pecos Road - Allen to Lindsay ST1820 2,962 - 342 2,620 - - - - -" & @CRLF & _
"" & @CRLF & _
"Higley Road - North of Elliot ST1830 1,523 - - 1,523 - - - - -" & @CRLF & _
"" & @CRLF & _
"Cooley Station Transit Center ST1840 10,306 - - - - 10,306 - - -" & @CRLF & _
"" & @CRLF & _
"Greenfield Road Right Turn Lane at Knox ST1850 613 - - 613 - - - - -" & @CRLF & _
"" & @CRLF & _
"Gilbert and Warner Intersection ST1860 11,493 178 53 11,262 - - - - -" & @CRLF & _
"" & @CRLF & _
"McQueen and Elliot Intersection ST1870 11,434 - - 11,434 - - - - -" & @CRLF & _
"" & @CRLF & _
"Lindsay and Guadalupe Intersection ST1880 12,608 - - - - 12,608 - - -" & @CRLF & _
"" & @CRLF & _
"Chandler Heights Improvements ST1890 3,000 - 3,000 - - - - - -" & @CRLF & _
"" & @CRLF & _
"McQueen and Guadalupe Intersection ST1910 12,369 - 2,987 9,382 - - - - -" & @CRLF & _
"" & @CRLF & _
"Val Vista and Ray Intersection ST1920 9,707 - - - - - - 9,707 -" & @CRLF & _
"" & @CRLF & _
"Power and Queen Creek Intersection ST1940 8,537 - - - - - - 8,537 -" & @CRLF & _
"" & @CRLF & _
"Market and Williams Field Interesction ST1960 813 48 39 - 726 - - - -" & @CRLF & _
"" & @CRLF & _
"Val Vista and Mercy Intersection ST1970 1,172 48 39 1,085 - - - - -" & @CRLF & _
"" & @CRLF & _
"Market and San Tan Village Intersection ST1980 1,342 55 35 - 1,252 - - - -"
Local $aArray = StringRegExp($sString, $sRegex, $STR_REGEXPARRAYGLOBALFULLMATCH)
Local $aFullArray[0]
For $i = 0 To UBound($aArray) -1
_ArrayConcatenate($aFullArray, $aArray[$i])
Next
$aArray = $aFullArray
; Present the entire match result
_ArrayDisplay($aArray, "Result")
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for AutoIt, please visit: https://www.autoitscript.com/autoit3/docs/functions/StringRegExp.htm