nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Searching field with upper or lower case

CCWeedcontrol

I have a script that works good but only if the first letter of the input has the first letter upper case.

Currently every road name starts with an upper case letter. How can I format the expression to allow for either upper or lower case inputs.

Thanks.

import arcpy  
arcpy.AddMessage("Starting")  
pu = arcpy.GetParameterAsText(0)  
arcpy.AddMessage(pu)  
mxd = arcpy.mapping.MapDocument("CURRENT")  
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]  
lyr = arcpy.mapping.ListLayers(mxd, "Roads", df)[0]

pu = arcpy.GetParameterAsText(0) 
arcpy.AddMessage(lyr.name)  
expression = "FENAME LIKE '%{}%'".format(pu) 
arcpy.AddMessage(expression)  
arcpy.SelectLayerByAttribute_management(lyr,"NEW_SELECTION",expression)  
df.extent = lyr.getSelectedExtent()  

arcpy.RefreshActiveView()  
arcpy.AddMessage("Completed")

Vind meer berichten getagd met

Accepted answers

DarrenWiens2

It looks like ArcGIS SQL uses UPPER() rather than UCASE().

Try:

UPPER(FENAME) LIKE '%{}%'".format(pu.upper())

All comments

CCWeedcontrol

does the UPPER() only for the first word or for more then one word?

The feature class attributes are like the following Desert Hills Road,Desert Wolf Lane etc.

DarrenWiens2

It looks like ArcGIS SQL uses UPPER() rather than UCASE().

Try:

UPPER(FENAME) LIKE '%{}%'".format(pu.upper())

CCWeedcontrol

thanks for the reply.

getting error on expression = "UCASE(FENAME)LIKE '%{}%'".format(pu.upper())

Traceback (most recent call last):

File "C:\GIS\Python Scripts\ZoomTo\ZoomToRoad.py", line 13, in <module>

arcpy.SelectLayerByAttribute_management(lyr,"NEW_SELECTION",expression)

File "c:\program files (x86)\arcgis\desktop10.2\arcpy\arcpy\management.py", line 6688, in SelectLayerByAttribute

raise e

ExecuteError: ERROR 000358: Invalid expression

DarrenWiens2

Force both sides to uppercase, then compare (untested):

expression = "UCASE(FENAME) LIKE '%{}%'".format(pu.upper())

If pu = 'elm street', it would be turned to 'ELM STREET'. It would then match capitalized versions of records like 'Elm Street', 'ELM Street', 'eLm StReEt', etc., all of which would be treated like 'ELM STREET'.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.