Hello, I am trying to move an address number field from a text to an integer field. The issue I am having is some of the addresses in the text field have spaces in them followed by a unit number. I already have another field with unit numbers so trying to figure out a way to mass updates these features. There is about 85000 of them.
Address Num example: 12345 01
Is there some sort of function (replace, trim?) where I can search for the space and delete everything after it in my text address number field?