We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
SOLVED

Split Street Number from address

jagjit_singh
8 - Asteroid

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

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus
Have you tried:

Getword([address],0)

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
jagjit_singh
8 - Asteroid

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
20 - Arcturus
20 - Arcturus
Regex_replace([house],"(\d+\W)(\d+)",'$2')

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

Cheers,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
LonnieY
Alteryx Alumni (Retired)

Parse Address tool?

Labels
Top Solution Authors