topic Re: Label Expression in Mapping Questions

Label Expression

lindajo04 — Wed, 31 Aug 2022 15:51:11 GMT

If the [Situs_Unit] field is blank on the parcel layer I would like the # sign to not show on the map labeling. Is there a way this can be accomplished?

This is my label expression for my parcel layer. [Situs_Num] & " " & [Situs_St] & " # " & [Situs_Unit]. If the parcel has info in this field, [Stius_Unit], it looks like this: 103 Park #421. If the parcel has no info in the unit field it looks like this: 124 Park #. is there a way in the expression to remove the # sign if the field is blank?

Thank you,

Linda Jo

Re: Label Expression

jcarlson — Wed, 31 Aug 2022 15:59:15 GMT

Any label expression language should allow you to use a conditional statement to build your label. It looks like you're using VBScript, is that right? I wouldn't know the specifics for that, if there's a particular reason you need VBScript, but it's fairly straightforward.

Re: Label Expression

KenBuja — Wed, 31 Aug 2022 18:03:25 GMT

You can build the label using VBScript this way

Function FindLabel ( [Situs_Num], [Situs_St], [Situs_Unit] ) FindLabel = [Situs_Num] + " " + [Situs_St] if ( [Situs_Unit] <> null ) then FindLabel += " #" + [Situs_Unit] end if End Function

Re: Label Expression

lindajo04 — Thu, 01 Sep 2022 16:53:37 GMT

Thank you for your feedback. When I try the expression this is what I get:
[cid:image001.png@01D8BDE8.A6716020]
[cid:image002.png@01D8BDE8.A6716020]
Any thoughts on what I did wrong?

Re: Label Expression

KenBuja — Thu, 01 Sep 2022 17:13:45 GMT

Can you reload those images?

Re: Label Expression

lindajo04 — Thu, 01 Sep 2022 20:42:37 GMT

Here is the response I get using the suggested code. Can you help me with what I did wrong?

[cid:image001.png@01D8BE08.8D43DB80][cid:image002.png@01D8BE08.8D43DB80]

Re: Label Expression

KenBuja — Thu, 01 Sep 2022 21:01:51 GMT

Unfortunately, the images that you're uploading don't seem to be working properly.

Re: Label Expression

lindajo04 — Thu, 01 Sep 2022 21:42:33 GMT

Here are the images I have been trying to send you.

Re: Label Expression

KenBuja — Thu, 01 Sep 2022 22:14:02 GMT

I had forgotten that VBScript doesn't have an incremental operator (+=).

Function FindLabel ( [Situs_Num], [Situs_St], [Situs_Unit] ) FindLabel = [Situs_Num] + " " + [Situs_St] if ( [Situs_Unit] <> null ) then FindLabel = FindLabel + " #" + [Situs_Unit] end if End Function

Is then field [Situs_Unit] a numeric field and does it have a null value or is it a string field with an empty string?