Allow Default Value to be blank

538
4
05-09-2013 05:50 AM
Status: Closed
Labels (1)
JustinSmith6
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. 

0EME0000000Td1J

4 Comments
RobertKlein3
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.
SSWoodward
Status changed to: Closed
 
Bud
by

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

SSWoodward

@Bud,

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.