Selecting features from partial string in where clause with variable of Select Layer By Attribute in ArcPy

Question

I am new to coding using ArcPy.
My code is:
roadname = "Ly Thuong Kiet"
arcpy.SelectLayerByAttribute_management("inLayer_lyr","NEW_SELECTION",""" "DIA_CHI" LIKE '{0}' """.format(roadname))

This code can run easily. However, I want to choose all the elements belonging to "DIA_CHI" field that have a name in the roadname.
Example: "Hem 32 Ly Thuong Kiet" will be contained in ("Ly Thuong Kiet").
When I wrote this code:
arcpy.SelectLayerByAttribute_management("inLayer_lyr","NEW_SELECTION",""" "DIA_CHI" LIKE "%Ly Thuong Kiet")

It can run. But when I use variable , I couldn't use percentage sign (%) in format.

radouxju · Accepted Answer

not the most "pythonic" solution, but you could simply avoid the .format by using string concatenation
arcpy.SelectLayerByAttribute_management("inLayer_lyr","NEW_SELECTION",""" "DIA_CHI" LIKE '%""" + roadname + "'")

PolyGeo · Answer

I would try doing it like this:
arcpy.SelectLayerByAttribute_management("inLayer_lyr","NEW_SELECTION","DIA_CHI LIKE '%{0}'".format(roadname))

Delimiters around field names have not been needed for quite a few versions and dispensing with them simplifies the syntax.

Selecting features from partial string in where clause with variable of Select Layer By Attribute in ArcPy

2 Answers

Add your own answers!

Ask a Question