topic Re: Field Calculator: A field name was not found... in Data Management Questions https://community.esri.com/t5/data-management-questions/field-calculator-a-field-name-was-not-found/m-p/80490#M4678 <HTML><HEAD></HEAD><BODY><SPAN>Well I think I figured it out... when I tried re-adding the Excel sheet, the Add Data dialog displayed it as Commercial-Active$' (that is, with a trailing quote mark). Removing the hyphen also got rid of the quote mark, and then everything played nicely.</SPAN><BR /><BR /><SPAN>Another mysterious ArcGIS workflow...</SPAN></BODY></HTML> Wed, 23 Jan 2013 17:27:22 GMT RobertMartin2 2013-01-23T17:27:22Z Field Calculator: A field name was not found... https://community.esri.com/t5/data-management-questions/field-calculator-a-field-name-was-not-found/m-p/80489#M4677 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><BR /><SPAN>I'm using the Field Calculator with some basic Python syntax to recalculate a field. The new data is coming from a joined Excel worksheet. My expression is:</SPAN><BR /><BR /><PRE class="plain" name="code">!'Commercial-Active$'.OLD![:-3]</PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>When I run this I get the error: "A field name was not found or there were unbalanced quotation marks." I know the field name is correct because I'm selecting it as-is from the Fields box. Does anyone know what this is all about?</SPAN><BR /><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Wed, 23 Jan 2013 17:07:13 GMT https://community.esri.com/t5/data-management-questions/field-calculator-a-field-name-was-not-found/m-p/80489#M4677 RobertMartin2 2013-01-23T17:07:13Z Re: Field Calculator: A field name was not found... https://community.esri.com/t5/data-management-questions/field-calculator-a-field-name-was-not-found/m-p/80490#M4678 <HTML><HEAD></HEAD><BODY><SPAN>Well I think I figured it out... when I tried re-adding the Excel sheet, the Add Data dialog displayed it as Commercial-Active$' (that is, with a trailing quote mark). Removing the hyphen also got rid of the quote mark, and then everything played nicely.</SPAN><BR /><BR /><SPAN>Another mysterious ArcGIS workflow...</SPAN></BODY></HTML> Wed, 23 Jan 2013 17:27:22 GMT https://community.esri.com/t5/data-management-questions/field-calculator-a-field-name-was-not-found/m-p/80490#M4678 RobertMartin2 2013-01-23T17:27:22Z