ArcGIS PRO 2.2: How to change spaces to Nulls?

BuckySwider

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.  

JoshuaBixby

Since you are talking about replacing blanks with NULL, I am assuming you are looking for columns with empty strings.  Do you just want to replace empty strings, "", or are you interested in replacing strings that only contain white space, e.g., "   "?

If this is just a once and done, and you don't care to script it, you can use Select By Attribute to select the rows, and then use the Field Calculator and set the Expression type to Python and value to None.  The Python None singleton gets converted to NULL when updating data in a table.