Allow Default Value to be blank

05-09-2013 05:50 AM
Status: Closed
Labels (1)
New Contributor II

There should be an option in geodatabases to set the default value to blank.  In many cases I do not want to see <NULL> where there is no value.  ESRI’s recommended workaround is to select all the <NULL> values and use the field calculator to make the selected values blank with “”.  I must now include this workaround into my workflows in order to have a blank record. 
Below is an image of road labels.  The label is concatenated with prefix direction, street name, street suffix, and postfix directional.  There are no values for prefix direction and postfix directional in the two road labels, so ArcGIS labels them with null by default. 
I can set the default value to be anything, but not blank.  It should take less work to have a record be blank, not more. 


Agreed.  Additionally there should be a more intelligent way to concatenate for labeling expressions, with conditional behavior based on whether a prefix direction field, e.g. is NULL.
Status changed to: Closed

@SSWoodward Is there an explanation as to why this idea was closed?



The Idea here was to allow for a way to not have the text "null" display when concatenating fields for labels. In the current version of ArcGIS Pro, fields with no value (<Null>) do not display the text "null" as they did in the version of the software that was used in the example.