Parsing Query

[tandon]

I am trying to parse address line in multiple fields

for below value 

2316 E 5th Ave,Denver,CO 80206-4205 - I am using "(\d+)\s(\w+\s\w+\s\w+),(\w+),(\w+)\s(\w+)-(\d+)" in regEx however it generated 6 fields which I understand. 

Below is output

However it didn;t work for value "8785 Cloverleaf Cir,Parker,CO 80134".

Is there a way to make it more dynamic ?

[binuacs · Accepted solution]

@tandon one way of doing this with the help of regex tool

[binuacs]

@tandon your initial RegEx did not work for the second text because the patters in different in order to work that you need to make some of the fields optional by using the ?

(\d+)\s(\w+\s?\w+\s?\w+?),(\w+),(\w+)\s(\w+)-?(\d+)?

[Alteryx_AR]

@tandon - Alteryx has the Parse Address tool. Refer here-

https://help.alteryx.com/current/designer/parse-address-tool