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