Split Street Number from address

[jagjit_singh]

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

[MarqueeCrew]

Have you tried:

Getword([address],0)

Cheers,

Mark

[jagjit_singh]

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

[MarqueeCrew · Accepted solution]

Regex_replace([house],"(\d+\W)(\d+)",'$2')

That will give you the digits following digits followed by a single non-word character.

Cheers,
Mark

[LonnieY]

Parse Address tool?