This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I have a field which contains streetnames and housenumbers. I need to put the house numbers into a sperate field.
Unfortunately sometimes the streets have 2 words with a space in between. So my thoughts are to start the split from the right side and not from the left. Because the house number is everytime after the last space (from left) or before the first space (from the right).
Upper Hillstreet 234
Very Up Hillstreet 66a
Top of Hillstreet 667
Is there a formula or a regex possible to split the housenumber based on the space before ?
If you can count on the pattern looking like your sample data, then an expression could be written that takes the first group of data (before a digit) and puts that into the first field and then takes the second group into another field. Note: I would drop the space before the digits in the process.
Here's the Expression:
Hopefully, this solves your challenge.
This workflow is saved in version 11.3.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.