topic inconsistent field names in Python Questions https://community.esri.com/t5/python-questions/inconsistent-field-names/m-p/411847#M32438 <HTML><HEAD></HEAD><BODY><SPAN>I need to extract data from 13 point FCs where each intersects with a user-input polygon, and then output certain attribute information from each to one summary excel file.&nbsp; The attribute info is basic stuff like name, address, city, state.&nbsp; However, complicating things, each FC has different field names for the same item, meaning one FC may have the address field as 'address' while another will have it as 'addr' and yet another as 'address_1'.&nbsp; Can anyone give advice or snippet or outline of how best to handle this?</SPAN></BODY></HTML> Thu, 11 Oct 2012 19:23:28 GMT MikeDriver 2012-10-11T19:23:28Z inconsistent field names https://community.esri.com/t5/python-questions/inconsistent-field-names/m-p/411847#M32438 <HTML><HEAD></HEAD><BODY><SPAN>I need to extract data from 13 point FCs where each intersects with a user-input polygon, and then output certain attribute information from each to one summary excel file.&nbsp; The attribute info is basic stuff like name, address, city, state.&nbsp; However, complicating things, each FC has different field names for the same item, meaning one FC may have the address field as 'address' while another will have it as 'addr' and yet another as 'address_1'.&nbsp; Can anyone give advice or snippet or outline of how best to handle this?</SPAN></BODY></HTML> Thu, 11 Oct 2012 19:23:28 GMT https://community.esri.com/t5/python-questions/inconsistent-field-names/m-p/411847#M32438 MikeDriver 2012-10-11T19:23:28Z Re: inconsistent field names https://community.esri.com/t5/python-questions/inconsistent-field-names/m-p/411848#M32439 <HTML><HEAD></HEAD><BODY><SPAN>Hi Mike</SPAN><BR /><BR /><SPAN>You could use wildcards for the field names.&nbsp; Ex:</SPAN><BR /><BR /><PRE class="lia-code-sample line-numbers language-none">fc = "Airports" lstFields = arcpy.ListFields(fc, "addr*") for field in lstFields: &nbsp;&nbsp; rows = arcpy.SearchCursor(fc) &nbsp;&nbsp; for row in rows: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print row.getValue(field.name) del row, rows</PRE><BR /><BR /><SPAN>The above code will print values for fields with names addr, address, address_1, etc.</SPAN></BODY></HTML> Sat, 11 Dec 2021 18:41:33 GMT https://community.esri.com/t5/python-questions/inconsistent-field-names/m-p/411848#M32439 JakeSkinner 2021-12-11T18:41:33Z