AnsweredAssumed Answered

Replace in Field Calculator

Question asked by justin.nettleton on Mar 4, 2020
Latest reply on Mar 5, 2020 by justin.nettleton

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 

Outcomes