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

Defintion query with apostrophe name

Pierre-LucBoivin

Hi,

I'm trying to create an sql expression with a variable "arrondissement" but there's a problem with some attributes that contain apostrophe (quote) in their names like :

Baie d'Urfé or L'île-Bizard-Sainte-Geneviève.

I've try a few things but i'm always getting an error due to the apostrophe. It's work fine with other names that doesn't have quote.

lyr.definitionQuery = '"Arrondisse"' + "=" + "'" + arrondissement + "'"
or
lyr.definitionQuery = '"Arrondisse"' + "=" + "'\"%s\"'" %(arrondissement)

Thanks you for your help

Vind meer berichten getagd met

Accepted answers

RichardFairhurst

Try:

lyr.definitionQuery = '"Arrondisse"' + "=" + "'" + arrondissement.replace("'","''") + "'"

If any apostrophes exist in the field's value each apostrophe will be doubled (no matter how many apostrophes are stored in the actual field value). If no apostrophe exists the field's value will be unchanged. Then you do not need to capture the values that contain apostrophes in any separate logic.

All comments

Pierre-LucBoivin

It's work perfectly with the replace

Thanks you for all you answer

RichardFairhurst

Try:

lyr.definitionQuery = '"Arrondisse"' + "=" + "'" + arrondissement.replace("'","''") + "'"

SepheFox

Try it like this (by the way, you have a misspelling in the word "definition" on line 4):

if lyr.definitionQuery == """"Arrondisse"=u"Baie-d'Urfé"""":
lyr.definitionQuery = """"Arrondisse"=u"Baie-d''Urfé""""

LukeWebb

I would try one of these:

#1 -  Use different types of quote. (EG Outer double quotes, inner single quote)
print "Hello there I'm Luke"


#2 - Use Triple quotes
print '''Hello there I'm Luke'''

#3 - Use ASCI Codes
print "Hello there I" + chr(39) + "m Luke"

Pierre-LucBoivin

Thanks for you answer Dan,

I found the reason why my script doesn't work, it's because Arcgis double my apostrophe in the attribute.

So i'm parsing this string to definition query in my script.

"Arrondisse"='Baie-d'Urfé'

and when I open the attributes tables my table is empty.

When i'm doing an selection by attribute and I double the apostrophe, it's works.

"Arrondisse" = 'Baie-d''Urfé'

but I can't figured out how to write it and make it works in my script.

if lyr.name == "Ecoles":
                    lyr.definitionQuery = '"Arrondisse"' + "=" + "'" + arrondissement + "'" 
                    if lyr.definitionQuery == """"Arrondisse"=u'Baie-d'Urfé'""":
                        lyr.defintionQuery = """"Arrondisse"=u'Baie-d''Urfé'"""

UnicodeWarning: Unicode equal comparison failed to convert both arguments to Unicode - interpreting them as being unequal

Thanks

DanPatterson_Retired

no sure if this is your desired output but you probably need to express it in Unicode. You can play around with this for testing

>>> x = u"Baie d'Urfé or L'île-Bizard-Sainte-Geneviève"
>>> x
u"Baie d'Urf\xe9 or L'\xeele-Bizard-Sainte-Genevi\xe8ve"
>>> print x
Baie d'Urfé or L'île-Bizard-Sainte-Geneviève
>>> z = '"Arrondisse"' + "=" + "'" + x + "'" 
>>> z
u'"Arrondisse"=\'Baie d\'Urf\xe9 or L\'\xeele-Bizard-Sainte-Genevi\xe8ve\''
>>> print z
"Arrondisse"='Baie d'Urfé or L'île-Bizard-Sainte-Geneviève'
>>>

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.