Regular Expressions 101

Explanation

Pro

Group Catergory(?<Catergory>.+[A-z]{2}\d{4})

.+any character (except for line terminators), repeated at least once

Character Class[A-z]{2}

{2}matches exactly 2 characters from the set below:

A-zone character from A (65₁₀) to z (122₁₀) (case sensitive)

\d{4}a digit, repeated exactly 4 times

\s+any whitespace character, repeated at least once

Group FY1(?<FY1>[\d.,-]+(?=\s))

Character Class[\d.,-]+

+matches at least one character from the set below:

\da digit

.the literal . (46₁₀ / 56₈ / 2E₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Positive Lookahead(?=\s)

\sany whitespace character

\s*any whitespace character, repeated any number of times

Group FY2(?<FY2>[\d.,-]+(?=\s))

Character Class[\d.,-]+

+matches at least one character from the set below:

\da digit

.the literal . (46₁₀ / 56₈ / 2E₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Positive Lookahead(?=\s)

\sany whitespace character

\s*any whitespace character, repeated any number of times

Group FY3(?<FY3>[\d.,-]+(?=\s))

Character Class[\d.,-]+

+matches at least one character from the set below:

\da digit

.the literal . (46₁₀ / 56₈ / 2E₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Positive Lookahead(?=\s)

\sany whitespace character

\s*any whitespace character, repeated any number of times

Group FY4(?<FY4>[\d.,-]+(?=\s))

Character Class[\d.,-]+

+matches at least one character from the set below:

\da digit

.the literal . (46₁₀ / 56₈ / 2E₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Positive Lookahead(?=\s)

\sany whitespace character

\s*any whitespace character, repeated any number of times

Group FY5(?<FY5>[\d.,-]+)

Character Class[\d.,-]+

+matches at least one character from the set below:

\da digit

.the literal . (46₁₀ / 56₈ / 2E₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\s*any whitespace character, repeated any number of times

Group FY6(?<FY6>[\d.,-]+)

Character Class[\d.,-]+

+matches at least one character from the set below:

\da digit

.the literal . (46₁₀ / 56₈ / 2E₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\s*any whitespace character, repeated any number of times

Group FY7(?<FY7>[\d.,-]+)

Character Class[\d.,-]+

+matches at least one character from the set below:

\da digit

.the literal . (46₁₀ / 56₈ / 2E₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\s*any whitespace character, repeated any number of times

Group FY8(?<FY8>[\d.,-]+)

Character Class[\d.,-]+

+matches at least one character from the set below:

\da digit

.the literal . (46₁₀ / 56₈ / 2E₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\s*any whitespace character, repeated any number of times

Group FY9(?<FY9>[\d.,-]+)

Character Class[\d.,-]+

+matches at least one character from the set below:

\da digit

.the literal . (46₁₀ / 56₈ / 2E₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

26 tokens

Regular Expression

(?<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.,-]+)

New

Return to Contents

Streets Improvement Summary

Capital Expenses (1,000s) Total Prior Years FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Years 6-10 Beyond 10
Yrs

Ocotillo Road - Greenfield to Higley ST0540 66,519 332 12,413 53,774 - - - - -

Baseline Road - Burk to Consolidated Canal ST0710 1,340 87 1,253 - - - - - -

Baseline Road - Greenfield to Power ST0780 8,801 112 - - - - 8,689 - -

Recker Road - Ocotillo to Chandler Heights ST0800 11,611 - - - - - - 11,611 -

Hunt Highway - Val Vista to 164th ST0840 86,241 40 - - - - - - 86,201

Recker Road - Ray to SR 202 ST0960 3,940 455 3,485 - - - - - -

Higley Road - Riggs to Stacey ST0980 20,403 1,973 - - - - - 18,430 -

Ocotillo Road - 148th to Greenfield ST0990 20,317 - 5,568 14,749 - - - - -

Elliot Road - Neely to Burk ST1050 4,060 - - - - - - - 4,060

Val Vista Drive - Appleby to Riggs ST1120 34,277 7,513 26,764 - - - - - -

Lindsay Road - Queen Creek to Ocotillo ST1140 3,881 171 1,097 2,613 - - - - -

Hunt Highway - Higley to Recker ST1