topic Re: Delete multiple fields in Python Questions

Delete multiple fields

DanielAbera — Mon, 22 Oct 2012 14:39:12 GMT

Hi Guys:

I am trying to use a pyhton script to delete multiple fields which are not in the list, but its not working. Any idea how to make is working. The code is as follows. Thanks.

import arcgisscripting, sys gp = arcgisscripting.create()    # set variables inputFc = sys.argv[1]  fdList = ['FID', 'Shape', 'MER', 'RGE', 'TWP', 'SEC', 'QS', 'Hectares']  fields = gp.ListFields(inputFc)   for field in fields:   if field.name not in fdList:        gp.deletefield_management(inputFc)

Re: Delete multiple fields

MathewCoyle — Mon, 22 Oct 2012 14:40:06 GMT

What version of ArcGIS are you running?

You also need to specify what field you want to delete.

gp.deletefield_management(inputFc, field.name)

Re: Delete multiple fields

DanielAbera — Mon, 22 Oct 2012 14:57:38 GMT

I am using 9.3.1, and I want to delete all but those specified in the list. I know you can delete multiple fields by hard coding the field names. But, I just want to something like to delete all except the field names specified. I can you ArcGIS 10.0 too.

Thanks,
Dan

Re: Delete multiple fields

MathewCoyle — Mon, 22 Oct 2012 15:07:56 GMT

Here is how I delete fields in 10.0. You have pretty much everything done already for 9.3.1.

dropFields = list() fieldList = arcpy.ListFields(block_out) keep_list = ["OBJECTID", "OID", "Geometry", "O_OID", "SOURCEID"] for f in fieldList:     if f.name not in keep_list and f.type not in keep_list:         dropFields.append(f.name) arcpy.DeleteField_management(block_out, dropFields)

Re: Delete multiple fields

DanielAbera — Mon, 22 Oct 2012 15:53:44 GMT

This is exactly what I was looking. Its works like charm.
Thanks a lot Matt !!!