split address into 3 columns.

[lbolin]

I am trying to parse an address into 3 rows. 

1730 N Wilson Way Stockton, CA 95205	1730 N Wilson Way	Stockton	CA	95205
6813 Cantrell Rd Little Rock, AR 72207	6813 Cantrell Rd	Little Rock	AR	72207
8512 Ridge Rd New Port Richey, FL 34654	8512 Ridge Rd	New Port Richey	FL	34654

[IraWatt]

Hey @lbolin,

You can use Regex with the Regex Tool to match to identify the parts:

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Emmanuel_G]

Hi @lbolin ,

Find attached the way to do it easily with regex tool.

[Alteryx_AR]

@lbolin Following expression in regex tool  parse the data-