topic Simple VBScript Label Expression for labelling certain records of a shapefile in ArcGIS Enterprise Portal Questions

Simple VBScript Label Expression for labelling certain records of a shapefile

KittyYiu — Wed, 25 Jul 2012 18:36:38 GMT

I have a water feature shapefile have the names of all the records (names of the lakes, rivers, creeks, etc), but I only want to label certain water features (the major lakes for example) and at the same time showing all the water features (that is not definition querying out certain records) on the map.

By default labelling it would label all the records, which is not my preference for the map visualization.

Is there a VBScript Label Expression for labelling certain records of a shapefile ?
(In this case, I know the names of the major water features which I want to label).

Because right now I has been labelling them one-by-one using the text tool, which is not quit efficient at times.

Re: Simple VBScript Label Expression for labelling certain records of a shapefile

DonovanCameron — Wed, 25 Jul 2012 20:03:23 GMT

You can apply a similar type of query that applies only to the labels.

Open the properties for that layer and go to the Label tab.

Select the field to label by (ie, [FEAT_NAME]) and press the "Expression" button.

Place a checkmark beside "advanced" and read over this recent thread on how to do just that.
http://forums.arcgis.com/threads/63054-Labels-again.-Sorry

Let the forum know if you have any issues.

In your case, you may need to incorporate a wildcard like the '%' operator, inStr function, or a regular expression.

Re: Simple VBScript Label Expression for labelling certain records of a shapefile

KittyYiu — Wed, 25 Jul 2012 20:28:08 GMT

It works, thanks.

[INDENT]Function FindLabel ( [NAME] )
if ( [NAME] = "Lake A" ) then
FindLabel = [NAME]
end if
End Function[/INDENT]

But how do I set it that it would only label the "Lake A", the "Lake B", and the "Lake C" ?

I don't think I can use wildcard like the '%' in my case, as sometime the names of the water features goes like this "Lake A", or "B Lake"; "B River", or "River B".

Re: Simple VBScript Label Expression for labelling certain records of a shapefile

DonovanCameron — Sat, 11 Dec 2021 20:56:13 GMT

But how do I set it that it would only label the "Lake A", the "Lake B", and the "Lake C" ?

I don't think I can use wildcard like the '%' in my case, as sometime the names of the water features goes like this "Lake A", or "B Lake"; "B River", or "River B".

If you have a small set of records you want to label, try using OR.

[LEFT]Function FindLabel ( [NAME] )
  if ( [NAME] = "Lake A" ) OR ( [NAME] = "Lake B" )  then
    FindLabel = [NAME]
  end if
End Function[/LEFT]

If your OR statement is getting large, try to incorporate the IN operator instead of OR.

[NAME] IN ('LAKE A', 'LAKE B', 'C LAKE')

Although I always have trouble including IN inside a vbscript label expression, mostly because the syntax is different depending on the data storage format (shapefiles vs geodatabase, etc...).