Hi All,
I have a set of property addresses as below and like to split the Street Number into a different column as in required output.
Address | Required output |
1 Inglis Road | 1 |
1/18 Normac Street | 18 |
11A Woodside Ave | 11A |
18-20 Ridge Road | 20 |
Thanks
Jag
Solved! Go to Solution.
that gave me the Street No but few had / or -. I used the regex formula below and get the desired result but wondering if this could have been achieved with a single regex statement
IF Contains([Street No], "-")
THEN REGEX_Replace([Street No], "\d\d\W", "")
ELSE REGEX_Replace([Street No], "\d\W", "")
ENDIF
Thanks
Jag
Parse Address tool?