topic Re: How to not display NULL Values in a string label in Geoprocessing Questions

How to not display NULL Values in a string label

KevinWyckoff2 — Mon, 20 Mar 2017 16:16:39 GMT

I have a feature class that I want to label based on three fields. It would be great if the first two fields always displayed, and the third only displayed when it isn't null. I have added all the field to a label no problem like this:

Is it possible to eliminate the word NULL in three of the five examples above?

Re: How to not display NULL Values in a string label

JayantaPoddar — Mon, 20 Mar 2017 16:54:21 GMT

You could use Using label classes to label features from the same layer differently—Help | ArcGIS for Desktop .

Create two classes and define SQL Query to identify the subset of the features you want to label in each class.

1. [Field3] IS NULL

2. [Field3] IS NOT NULL

Label Expression for Class 1

[Field1] + " " + [Field2]

Label Expression for Class 2

[Field1] + " " + [Field2] + " " + [Field3]

Re: How to not display NULL Values in a string label

JoshuaBixby — Sun, 12 Dec 2021 07:34:11 GMT

In addition to using label classes, you can define a FindLabel function (make sure to check 'Advanced'):

Expression:

def FindLabel( [Field1], [Field2], [Field3] ):
    return " ".join(str(field) for field in ( [Field1], [Field2], [Field3] ) if field)‍‍

Parser:

Python

Re: How to not display NULL Values in a string label

NinaRihn — Fri, 24 Mar 2017 21:31:41 GMT

you could add this vb expression:

Function FindLabel ([field 1], [field 2], [field 3])
If [field 3] <> " " then
FindLabel = [field 1] & " " & [field 2] & " " & [field 3]
else
FindLabel = [field 1] & " " & [field 2]
end if
End Function

this works for me even with Null values

Re: How to not display NULL Values in a string label

AbdullahAnter — Fri, 24 Mar 2017 22:02:31 GMT

If you have Null values in your field , it is automatically doesn't appear in label.

Just use simple expression: parser VBScript >

[Field1] & [Field2] &[Field3]

Re: How to not display NULL Values in a string label

NinaRihn — Mon, 27 Mar 2017 13:10:33 GMT

that is true, however the vb expression comes in handy if you would like to add characters or spaces between each value, like this:

Function FindLabel ([field 1], [field 2], [field 3])
If [field 3] <> " " then
FindLabel = [field 1] & "-" & [field 2] & "-" & [field 3]
else
FindLabel = [field 1] & "-" & [field 2]
end if
End Function

then the last dash doesn't show up if the last value is null