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