Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

split address into 3 columns.

lbolin
8 - Asteroid

I am trying to parse an address into 3 rows. 

1730 N Wilson Way Stockton, CA 952051730 N Wilson WayStocktonCA95205
6813 Cantrell Rd Little Rock, AR 722076813 Cantrell RdLittle RockAR72207
8512 Ridge Rd New Port Richey, FL 346548512 Ridge RdNew Port RicheyFL34654
3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @lbolin,

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

IraWatt_0-1662757525334.png

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
13 - Pulsar

Hi @lbolin ,

 

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

 

Emmanuel_G_0-1662804454543.png

 

Alteryx_AR
12 - Quasar

@lbolin Following expression in regex tool  parse the data-

 

Alteryx_AR_0-1662815518661.png

 

Labels
Top Solution Authors