topic Re: variable within a whereclause in Transportation Questions https://community.esri.com/t5/transportation-questions/variable-within-a-whereclause/m-p/87083#M326 <HTML><HEAD></HEAD><BODY><SPAN>You'd just need to use string substitution. Something like this.</SPAN><BR /><BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro">exp = '"SystemOwner" = \'{0}\''.format(variable)</PRE></BODY></HTML> Mon, 17 Jun 2013 21:47:08 GMT MathewCoyle 2013-06-17T21:47:08Z variable within a whereclause https://community.esri.com/t5/transportation-questions/variable-within-a-whereclause/m-p/87082#M325 <HTML><HEAD></HEAD><BODY><SPAN>I am a novice with arcpy.</SPAN><BR /><BR /><SPAN>I would like to use the arcpy.Select_analysis to select a featureclass with a selection based on an attibute and a txtfile. </SPAN><BR /><SPAN>All is working except that the where clasue does not like it when I try to install a variable.&nbsp; Such as:</SPAN><BR /><BR /><SPAN>arcpy.Select_analysis(fromFC, line[:-1]+"\\output_temp", exp)</SPAN><BR /><BR /><SPAN>the FromFC is the FC I am coping from. </SPAN><BR /><SPAN>the line[:-1]+"\\output_temp" is the FC I am pushing the selection of the FromFC to, ans</SPAN><BR /><SPAN>exp is the expression -&nbsp; exp = '"SystemOwner" = \'Rockingham\''</SPAN><BR /><BR /><SPAN>Rockingham is in the place I would like to put the variable as I have several towns to run through.&nbsp; I am not sure of the syntax by which to add the variable, as defined in an open statement for a textfile.</SPAN><BR /><BR /><SPAN>Any ideas or suggestions?</SPAN></BODY></HTML> Mon, 17 Jun 2013 21:36:35 GMT https://community.esri.com/t5/transportation-questions/variable-within-a-whereclause/m-p/87082#M325 JamesArmstrong 2013-06-17T21:36:35Z Re: variable within a whereclause https://community.esri.com/t5/transportation-questions/variable-within-a-whereclause/m-p/87083#M326 <HTML><HEAD></HEAD><BODY><SPAN>You'd just need to use string substitution. Something like this.</SPAN><BR /><BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro">exp = '"SystemOwner" = \'{0}\''.format(variable)</PRE></BODY></HTML> Mon, 17 Jun 2013 21:47:08 GMT https://community.esri.com/t5/transportation-questions/variable-within-a-whereclause/m-p/87083#M326 MathewCoyle 2013-06-17T21:47:08Z