Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This might be one of those slap your forehead so simple questions.

In ArcMap, how can I use wildcards to aid with map symbology? For the example below, I have tried adding values such as "Field *" and "Field %" but have not had any luck. This would be convenient with tables of 4000+ records with different ending comments.

Field Verify

Field Verify - Unclogged

Field Verify - Too Much Traffic

Field Verify - Under Fence

Field Verify - Buried

Field Verify - Under Asphalt

Edit: I am scratching around with this code, except I would like it to first group the results and then insert, instead of replacing, the group into the existing symbology. I use the field name, and then repeat the field name in the query, so that tField = FID and tQuery = FID > 500

import arcpy

tLayer = arcpy.GetParameterAsText(0)
tField = arcpy.GetParameterAsText(1)
tQuery = arcpy.GetParameterAsText(2)

mxd = arcpy.mapping.MapDocument("current")
lyr = arcpy.mapping.ListLayers(mxd, tLayer)[0]
arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", tQuery)
fList = []
rows = arcpy.da.SearchCursor(lyr, [tField])
for row in rows:

if lyr.symbologyType == "UNIQUE_VALUES":
  lyr.symbology.classValues = fList
  lyr.symbology.showOtherValues = False

del mxdde here
share|improve this question
up vote 2 down vote accepted

As far as I know, this can't be accomplished directly in the symbology of a layer easily. You'll have to create a new field, such as "Type" or "Symbology Type", and then calculate the type/symbology of each record based on an expression.

The simplest way would be to use a definition query to create groups of layers, then field calculate your new Symbol_Type field such that all the records in the query would have = "Fence" or whatever.

Once you've done that, you can symbolize based on your new type field.

share|improve this answer
Woke up this morning, drinking coffee and your solution made perfect sense. Create multiple layers from the same source then query & symbolize each layer accordingly. – Barrett Jun 5 '13 at 13:44

LIKE 'Field%' will be need to get the field, and the field ???.
the space.
Here are examples.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.