split address into 3 columns.

Question

I am trying to parse an address into 3 rows.

1730 N Wilson Way Stockton, CA 952051730 N Wilson WayStocktonCA952056813 Cantrell Rd Little Rock, AR 722076813 Cantrell RdLittle RockAR722078512 Ridge Rd New Port Richey, FL 346548512 Ridge RdNew Port RicheyFL34654

Alteryx_AR · Answer

@lbolin Following expression in regex tool  parse the data-

Emmanuel_G · Answer

Hi @lbolin ,

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

Split address into 3 columns.yxmd

IraWatt · Answer

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%20Data

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd