topic Change a blank field to NULL in Data Management Questions https://community.esri.com/t5/data-management-questions/change-a-blank-field-to-null/m-p/44334#M2517 <HTML><HEAD></HEAD><BODY><SPAN>In ArcGIS 10.2, is there a way to change a lot of blank fields to &lt;NULL&gt;?</SPAN><BR /><BR /><SPAN>The properties are set to accept NULL values, but it is only populating the new features with NULL. All of the existing features have just been left blank.</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Fri, 11 Apr 2014 19:12:56 GMT AprilChipman1 2014-04-11T19:12:56Z Change a blank field to NULL https://community.esri.com/t5/data-management-questions/change-a-blank-field-to-null/m-p/44334#M2517 <HTML><HEAD></HEAD><BODY><SPAN>In ArcGIS 10.2, is there a way to change a lot of blank fields to &lt;NULL&gt;?</SPAN><BR /><BR /><SPAN>The properties are set to accept NULL values, but it is only populating the new features with NULL. All of the existing features have just been left blank.</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Fri, 11 Apr 2014 19:12:56 GMT https://community.esri.com/t5/data-management-questions/change-a-blank-field-to-null/m-p/44334#M2517 AprilChipman1 2014-04-11T19:12:56Z Re: Change a blank field to NULL https://community.esri.com/t5/data-management-questions/change-a-blank-field-to-null/m-p/44335#M2518 <HTML><HEAD></HEAD><BODY><SPAN>April,</SPAN><BR /><BR /><SPAN>select all the fields that have an empty value, right click the column and chose "Field Calculator..." and just type </SPAN><PRE class="plain" name="code">null</PRE><DIV style="display:none;"> </DIV><SPAN> in the box and click OK.</SPAN><BR /><BR /><SPAN>This will change all the empty values to &lt;Null&gt;</SPAN><BR /><BR /><SPAN>Hope this helps!</SPAN><BR /><BR /><SPAN>Tim</SPAN></BODY></HTML> Fri, 11 Apr 2014 19:16:36 GMT https://community.esri.com/t5/data-management-questions/change-a-blank-field-to-null/m-p/44335#M2518 TimWitt 2014-04-11T19:16:36Z