I have an
ADDRESS field in a table with values like:
- 1 MAIN ST
- 20 SIDE AVE W
- 300 JOHN DOE JR RD S
I want to use the field calculator to split the addresses and insert the parts into
JOHN DOE JR RD Sinto
I also want the tool to check if the value that will be put into
HOUSE_NUMBER is a valid integer (and ignore it if it isn't).
How can I do this?