topic Re: Searching field with upper or lower case in Python Questions

Searching field with upper or lower case

CCWeedcontrol — Sat, 11 Dec 2021 07:03:50 GMT

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")

Re: Searching field with upper or lower case

DarrenWiens2 — Thu, 05 Nov 2015 17:18:27 GMT

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'.

Re: Searching field with upper or lower case

CCWeedcontrol — Thu, 05 Nov 2015 17:26:56 GMT

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

Re: Searching field with upper or lower case

DarrenWiens2 — Thu, 05 Nov 2015 17:31:55 GMT

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

Try:

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

Re: Searching field with upper or lower case

CCWeedcontrol — Thu, 05 Nov 2015 17:38:35 GMT

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.

Re: Searching field with upper or lower case

CCWeedcontrol — Thu, 05 Nov 2015 17:43:01 GMT

Looks like it does. Thanks.

Re: Searching field with upper or lower case

DarrenWiens2 — Thu, 05 Nov 2015 17:44:28 GMT

UPPER() applies to the entire string within the parentheses: e.g. UPPER('Desert Hills') = 'DESERT HILLS'