Set empty strings to null

1826
3
03-29-2013 06:31 AM
NoahHuntington
Occasional Contributor
How do I calculate field to replace empty strings with Null? I realize there is a Set Null tool available with the spatial analyst extension.  Without this is there another way?
Tags (2)
0 Kudos
3 Replies
LeoDonahue
Occasional Contributor III
Do a select by attributes on the field using '' as the expression to select empty strings.

Field calculate using: null  as the expression.
0 Kudos
NoahHuntington
Occasional Contributor
Generated "Not Nullable" error on field.  Where can I change this?
0 Kudos
LeoDonahue
Occasional Contributor III
When you created your featureclass, and added that field, there was an option for allowing nulls.  It's probably set to No.  I don't think you can change it without recreating the featureclass.
0 Kudos