topic Re: How to Get Rid of Quotes in the SQL expression in Python Questions https://community.esri.com/t5/python-questions/how-to-get-rid-of-quotes-in-the-sql-expression/m-p/494306#M38787 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi Babak,<BR />In the query, try stripping the double quotes:<BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro">lyr.definitionQuery =&nbsp; '{0} in ({1})' .format(newName.strip('"'), queryList)</PRE></BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Thank you Kerry</SPAN><BR /><BR /><SPAN>It works.</SPAN></BODY></HTML> Fri, 15 Mar 2013 14:21:14 GMT babakkasraei 2013-03-15T14:21:14Z How to Get Rid of Quotes in the SQL expression https://community.esri.com/t5/python-questions/how-to-get-rid-of-quotes-in-the-sql-expression/m-p/494304#M38785 <HTML><HEAD></HEAD><BODY><SPAN>I have some codes in my script like this.</SPAN><BR /><BR /><PRE class="plain" name="code"> queryList = selectedFids.replace(';', ',') &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; newName = arcpy.AddFieldDelimiters(lyr, "[OBJECTID]") &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lyr.definitionQuery =&nbsp; '{0} in ({1})' .format(newName, queryList) </PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>In the second line for AddFieldDElimiters properties I have to use Quotes for [OBJECTID] to work. </SPAN><BR /><BR /><SPAN>In my SQL query I must only use [OBJECTID] without quotes, but quotes come to my query from newName. </SPAN><BR /><BR /><SPAN>I need to get rid of the quotes in the sql query. How can I do that?</SPAN><BR /><BR /><SPAN>Please help me.</SPAN><BR /><BR /><SPAN>Best regards </SPAN><BR /><BR /><SPAN>Babak</SPAN></BODY></HTML> Fri, 15 Mar 2013 00:03:52 GMT https://community.esri.com/t5/python-questions/how-to-get-rid-of-quotes-in-the-sql-expression/m-p/494304#M38785 babakkasraei 2013-03-15T00:03:52Z Re: How to Get Rid of Quotes in the SQL expression https://community.esri.com/t5/python-questions/how-to-get-rid-of-quotes-in-the-sql-expression/m-p/494305#M38786 <HTML><HEAD></HEAD><BODY><SPAN>Hi Babak,</SPAN><BR /><SPAN>In the query, try stripping the double quotes:</SPAN><BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro">lyr.definitionQuery =&nbsp; '{0} in ({1})' .format(newName.strip('"'), queryList)</PRE></BODY></HTML> Fri, 15 Mar 2013 14:00:51 GMT https://community.esri.com/t5/python-questions/how-to-get-rid-of-quotes-in-the-sql-expression/m-p/494305#M38786 KerryAlley 2013-03-15T14:00:51Z Re: How to Get Rid of Quotes in the SQL expression https://community.esri.com/t5/python-questions/how-to-get-rid-of-quotes-in-the-sql-expression/m-p/494306#M38787 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi Babak,<BR />In the query, try stripping the double quotes:<BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro">lyr.definitionQuery =&nbsp; '{0} in ({1})' .format(newName.strip('"'), queryList)</PRE></BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Thank you Kerry</SPAN><BR /><BR /><SPAN>It works.</SPAN></BODY></HTML> Fri, 15 Mar 2013 14:21:14 GMT https://community.esri.com/t5/python-questions/how-to-get-rid-of-quotes-in-the-sql-expression/m-p/494306#M38787 babakkasraei 2013-03-15T14:21:14Z