Change a blank field to NULL

4084
1
Jump to solution
04-11-2014 12:12 PM
AprilChipman1
New Contributor II
In ArcGIS 10.2, is there a way to change a lot of blank fields to <NULL>?

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.

Thanks!
0 Kudos
1 Solution

Accepted Solutions
TimWitt
Frequent Contributor
April,

select all the fields that have an empty value, right click the column and chose "Field Calculator..." and just type
null
in the box and click OK.

This will change all the empty values to <Null>

Hope this helps!

Tim

View solution in original post

1 Reply
TimWitt
Frequent Contributor
April,

select all the fields that have an empty value, right click the column and chose "Field Calculator..." and just type
null
in the box and click OK.

This will change all the empty values to <Null>

Hope this helps!

Tim