topic Re: Python Triple Quotes Escape Stroke in Python Questions

Python Triple Quotes Escape Stroke

GeoffOlson — Wed, 01 Oct 2014 20:27:53 GMT

I'm using Python to run a script, but I've run into a small problem. I'm using triple quotes to form a definition query, but inside the query is a wildcard %, so the interpreter is expecting a variable to format the string. Is there a stroke key that can be used?

mapLyr2.definitionQuery = """"FID" IN (%s) AND "Jurisdicti" NOT LIKE '% Township'""" %dqStr

Re: Python Triple Quotes Escape Stroke

SusanJones — Wed, 01 Oct 2014 21:06:15 GMT

Geoff:

Try breaking your query string up and using a combination of ' and ".

e.g.

queryString = r'"FID" in (%s) and "Jurisdicti" like ' + '\'\% Township\''

Re: Python Triple Quotes Escape Stroke

JasonScheirer — Wed, 01 Oct 2014 21:37:02 GMT

Use %%.

>>> """x like 'hello%' and y = %s"""
"x like 'hello%' and y = %s"
>>> """x like 'hello%' and y = %s"""%"what"
Traceback (most recent call last):
  File "", line 1, in ValueError: unsupported format character ''' (0x27) at index 14
>>> """x like 'hello%%' and y = %s"""%"what"
"x like 'hello%' and y = what"

Re: Python Triple Quotes Escape Stroke

curtvprice — Thu, 02 Oct 2014 02:23:33 GMT

I've become more of a fan of the Python 2.x/3.x string formatting:

mapLyr2.definitionQuery = """"FID" IN ({}) AND "Jurisdicti" NOT LIKE '% Township'""".format(dqStr)

I like to break things up into multiple lines with () to make it easier to read and debug. Note that if you place parentheses around the expression, it will get glommed together for you into a single string for .format() to process - look ma, no line continuation characters! So elegant.

mapLyr2.definitionQuery = (
    """"FID" IN ({}) AND """
    """"Jurisdicti" NOT LIKE '% Township'""").format(dqStr)

I'm with Susan -- I also find triple quotes kind of clunky - but this is of course totally personal preference!

mapLyr2.definitionQuery = (
    '"FID" IN ({}) AND '
    '"Jurisdicti" NOT LIKE \'% Township\'').format(dqStr)

Re: Python Triple Quotes Escape Stroke

GeoffOlson — Thu, 02 Oct 2014 17:23:34 GMT

Thank you all for the replies. I will keep this in mind. Triple quotes was my immediate solution when I realized I had both single and double quotes for the query. My temporary solution for this was to create a string variable that was the entire wildcard part '% Township' and that worked, but I don't want to keep creating variables just for the purpose of a workaround.

Re: Python Triple Quotes Escape Stroke

JuanOrozco — Thu, 02 Oct 2014 17:44:09 GMT

Another option is to use the ascii code for the character you're having trouble with. chr(37) would give you %; you just need to place it in the query string. You can deal with combinations of double and single quotes using the same approach, but it can get confusing in long queries.

mapLyr2.definitionQuery = 'FID IN ('+chr(37)+'s) AND '+chr(34)+'Jurisdicti'+chr(34)+' NOT LIKE ' + chr(37)+chr(39)+' Township'+chr(39)

mapLyr2.definitionQuery = 'FID IN ('+chr(37)+'s) AND '+chr(34)+'Jurisdicti'+chr(34)+' NOT LIKE ' + chr(37)+"'" Township"'"