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; } } }

Apostrophe in query

WilsonIonara

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

Vind meer berichten getagd met

Accepted answers

MathewCoyle

Does this work for you?

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

All comments

WilsonIonara

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!!!

ChrisSnyder

This format works for me:

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

WilsonIonara

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)

MathewCoyle

Does this work for you?

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

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.