Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
^\d+,[a-zA-Z0-9 ]+(?=,[a-zA-Z ]+,5)
/
gm
Input 1
New
Street Number,Street Name,Street Side,Number of Racks,Year Installed 1351,Adanac St,North,2,2015 1375,Adanac St,North,1,2015 55,Alexander St,North,1,Prior 2010 90,Alexander St,South,10,2013 305,Alexander St,North,1,2012 320,Alexander St,South,2,2014 429,Alexander St,North,2,2015 475,Alexander St,North,2,2012 611,Alexander St,North,3,2015 200,Alexander St,North,2,2012 2576,Arbutus St,East,1,2015 2620,Arbutus St,East,1,2015 2630,Arbutus St,East,1,2015 2680,Arbutus St,East,1,2015 2738,Arbutus St,East,1,2015 5723,Balsam St,West,2,Prior 2010 1447,Barclay St,North,1,2013 2486,Bayswater St,East,1,2011 546,Beatty St,East,1,2011 550,Beatty St,East,2,2016 590,Beatty St,East,2,2012 600,Beatty St,East,2,2016 620,Beatty St,East,6,2016 773,Beatty St,West,3,2016 780,Beatty St,East,2,2011 780,Beatty St,East,1,2016 837,Beatty St,West,1,2011 855,Beatty St,East,2,2016 857,Beatty St,West,2,2016 869,Beatty St,West,1,2016 928,Beatty St,East,7,2016 939,Beatty St,West,1,2016 2400,Birch St,West,1,2012 2400,Ble