regex101: discard rubbish, GEO, NUMBERS, NAME, TYPE

(?ix)applies the following effective flags to the remainder of the pattern: gix

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

x modifier: extended. Ignores unescaped whitespace and comments outside character classes

Non-Capturing Group(?:^[A-Z\W]*\W+(?!bnd|cnr)\W+)?

?repeats the group contents below at most once:

^start of string

Character Class[A-Z\W]*

*matches any number of characters from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case insensitive)

\Wany character that is not a Unicode word character

\W+any character that is not a Unicode word character, repeated at least once

Negative Lookahead(?!bnd|cnr)

1st Alternativebnd

bndthe literal text bnd (case insensitive)

2nd Alternativecnr

cnrthe literal text cnr (case insensitive)

\W+any character that is not a Unicode word character, repeated at least once

*?repeats the group contents below any number of times:

Negative Lookahead(?!\b(?:RD|HWY|TRAIL|St|R)\b)

\ba Unicode word boundary

Non-Capturing Group(?:RD|HWY|TRAIL|St|R)

1st AlternativeRD

RDthe literal text RD (case insensitive)

2nd AlternativeHWY

HWYthe literal text HWY (case insensitive)

3rd AlternativeTRAIL

TRAILthe literal text TRAIL (case insensitive)

4th AlternativeSt

Stthe literal text St (case insensitive)

5th AlternativeR

Rthe literal R (82₁₀ / 122₈ / 52₁₆) (case insensitive)

\ba Unicode word boundary

Group numbers(?P<numbers>\d+-\d+|\d+[A-Z]?)

1st Alternative\d+-\d+

\d+a Unicode decimal digit, repeated at least once

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

\d+a Unicode decimal digit, repeated at least once

2nd Alternative\d+[A-Z]?

\d+a Unicode decimal digit, repeated at least once

Character Class[A-Z]?

?matches at most one character from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case insensitive)

\W+any character that is not a Unicode word character, repeated at least once

Non-Capturing Group(?:\W+(?:AND|&)\W+)*

*repeats the group contents below any number of times:

\W+any character that is not a Unicode word character, repeated at least once

Non-Capturing Group(?:AND|&)

1st AlternativeAND

ANDthe literal text AND (case insensitive)

2nd Alternative&

&the literal & (38₁₀ / 46₈ / 26₁₆)

\W+any character that is not a Unicode word character, repeated at least once

Non-Capturing Group(?:(?:(?P<geo>BND|CNR)(?:\WOF|\WBY)?)\W+)*

*repeats the group contents below any number of times:

Non-Capturing Group(?:(?P<geo>BND|CNR)(?:\WOF|\WBY)?)

Group geo(?P<geo>BND|CNR)

1st AlternativeBND

2nd AlternativeCNR

Non-Capturing Group(?:\WOF|\WBY)?

\W+any character that is not a Unicode word character, repeated at least once

Group name(?P<name>(?:(?!\b(?:RD|HWY|TRAIL|St|R)\b)[A-Z]+\W*)+)

\W+any character that is not a Unicode word character, repeated at least once

Non-Capturing Group(?:(?P<type>RD|HWY|TRAIL|St|R)\W)+

Global pattern flags

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

Search reference

Regular Expression

(?ix)(?:^[A-Z\W]*\W+(?!bnd|cnr)\W+)?(?:(?!\b(?:RD|HWY|TRAIL|St|R)\b)(?P<numbers>\d+-\d+|\d+[A-Z]?)\W+)*?(?:\W+(?:AND|&)\W+)*(?:(?:(?P<geo>BND|CNR)(?:\WOF|\WBY)?)\W+)*(?P<name>(?:(?!\b(?:RD|HWY|TRAIL|St|R)\b)[A-Z]+\W*)+)\W+(?:(?P<type>RD|HWY|TRAIL|St|R)\W)+

New

convention centre, bnd by swanston st and avoca st
cnr the hyatt and roland st 123 hudson st BND BY THOMAS RAIL TRAIL, 7 SNOW WHITE HWY & MICKEY RD, 337-343 BOGEYMAN RD, 4, 8, 9-13, 16-18 Fictional Rd & 17B Elm St near junction

Regular Expressions 101

Regular Expression

Extraction