How to parse out the address

[yuanli1]

Hello,

I am a beginner in Alteryx. Can anyone please help how to parse out these addresses? 

The format of the solution is like: Address, City, State, Zip Code and Country, and they are in five different columns. Thank you! 

[gautiergodard]

@yuanli1 Here is one way that will get you close, there are some inconsistencies in the way your addresses are entered which caused the regex to be imperfect

Hope this helps!

[flying008]

Hi, @yuanli1 

Maybe you can try this way:

1- Formula for [Address] to fix layout :

Trim(IIF(REGEX_Match([Address],"^[[:alnum:]\s]+?\n(\d+?[[:alpha:]]+?|[[:alpha:]]+?\d+?)\n.+?$"),ReplaceFirst([Address], "
", " "),[Address]))

2- Split by newLine "\n"

3- Parse by RegEx expression:

^([[:alpha:]\s]+?),\s([a-zA-Z\s]+?)\s(.+?)$

4- Select you want output fields and rename.

******

If it can help you , please mark it as a solution and give a like to here.