AnsweredAssumed Answered

ArcGIS PRO 2.2:  How to change spaces to Nulls?  

Question asked by buckyswider on Nov 2, 2018
Latest reply on Nov 20, 2018 by ldmitruk@edmonton.ab.ca

ArcGIS PRO 2.2:  How to change spaces to Nulls?   

Hi all, running a canned project "Fire ServiceMaps" in which a task wants me to append my Street Centerlines file into the LocalGovernment model.  The target field is defined as a long integer that accepts null values.  However, it looks like my input file has some spaces in it so the append fails with ERROR 001156.  

 

I searched around trying to find a way to convert the spaces in my source to NULL values, but nothing I could get to work.  What is the best/easiest ways to search a column for blanks and replace with NULL in Pro 2.2?

 

Thanks.  

Outcomes