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

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

Split Street Number from address

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

Regex

Accepted answers

MarqueeCrew

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

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

Cheers,
Mark

All comments

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

LonnieY

Parse Address tool?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235