Replace in Field Calculator

1821
10
Jump to solution
03-04-2020 03:56 PM
JustinNettleton1
New Contributor III

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?

Thanks, 

Justin 

0 Kudos
10 Replies
JustinNettleton1
New Contributor III

This did it. 

Thanks for all the help. 

0 Kudos