Apostrophe in query

ionarawilson1 — Mon, 19 Nov 2012 14:46:20 GMT

How can I make this query work?

query = '"CLASS" = \'Z'berg Park\''

I know it is not working because of the apostrophe on the name. Any ideas on what I should change? Thanks

Re: Apostrophe in query

MathewCoyle — Mon, 19 Nov 2012 15:00:44 GMT

Does this work for you?

query = """"CLASS" = 'Z''berg Park'"""

Re: Apostrophe in query

ionarawilson1 — Sat, 11 Dec 2021 18:50:31 GMT

Matthew,

Thanks for your help. But I am still getting an error message when I run the code. Please see code snippet:

import arcpy, sys, traceback

arcpy.env.workspace = "C:\\PYTHON_PRIMER\\Chapter05\\Data\\"

street_class2 = "Sacramento_Streets.shp"
street_layer2 = "Streets"
out_streets2 = "out_streets.shp"
neighborhood_class2 = "Sacramento_Neighborhoods.shp"
neighborhood_layer2 = "Neighborhoods"




try:

    # 1. Make a feature layer for streets

    if arcpy.Exists(neighborhood_layer2):
        arcpy.Delete_management(neighborhood_layer2)

    arcpy.MakeFeatureLayer_management(neighborhood_class2, neighborhood_layer2)

    # 2. Create a query statement to select highways

    query = """"CLASS" = 'Z''berg Park'"""

    # 3. Select by attributes using the query

    # Select features by attribute using query
    arcpy.SelectLayerByAttribute_management(neighborhood_layer2, "NEW_SELECTION", query)
    result2 = arcpy.GetCount_management(neighborhood_layer2)
    print "Number of selected features in the feature layer " + neighborhood_layer2 + " with a query: "+ str(result2)

    # 4. Make feature layer

    if arcpy.Exists(street_layer2):
        arcpy.Delete_management(street_layer2)

    arcpy.MakeFeatureLayer_management(street_class2, street_layer2)


   # Create query statement
    query2 = '"CLASS" = \'C\''


   #4.a Select "local" streets inside Meadowview
    arcpy.SelectLayerByAttribute_management(street_layer2, "NEW_SELECTION", query2)

And the error message:

PYTHON ERRORS:
Traceback Info:
File "C:\PYTHON_PRIMER\Chapter05\exercise5extra.py", line 48, in <module>
arcpy.SelectLayerByAttribute_management(neighborhood_layer2, "NEW_SELECTION", query)

Error Info:
<class 'arcgisscripting.ExecuteError'>: ERROR 000358: Invalid expression
Failed to execute (SelectLayerByAttribute).

Line 48 is: arcpy.SelectLayerByAttribute_management(neighborhood_layer2, "NEW_SELECTION", query)

Re: Apostrophe in query

ChrisSnyder — Mon, 19 Nov 2012 17:27:05 GMT

This format works for me:

query = "CLASS = 'Z''berg Park'"

Re: Apostrophe in query

ionarawilson1 — Mon, 19 Nov 2012 17:56:22 GMT

Chris, your expression did not work on my case but Matthew's expression did after I changed the name of the field (it was not CLASS but NAME):

query = """"NAME" = 'Z''berg Park'"""

Thank you both for your help!!!

topic Re: Apostrophe in query in Python Questions

Apostrophe in query

Re: Apostrophe in query

Re: Apostrophe in query

Re: Apostrophe in query

Re: Apostrophe in query