Delete 1st field/column

MathieuCain

Hello,

I am in the process of creating a model that will take GIS features and create all the necessary inputs needed for use in an external 3D modelling software, including legend files. What I'm struggling with is getting the legend file into an appropriate csv output with only very specific information (e.g., no extra fields, or records).

Using the "Additional Conversion - Generic Tools" http://resources.arcgis.com/gallery/file/geoprocessing/details?entryID=95009B25-1422-2418-7FB5-B8638ECB2FA9 tool I am now able to export a table to a csv. However the csv still contains an ID field (i.e., first field) which I would like to remove automatically through the geoprocessing model.

Is there some simple python code I can use for this and if so how do I incorporate it into the model in ArcCatalog?

Thanks!

curtvprice

Sorry, you're right, this tool (and the python script it calls, \ArcGIS\Desktop10.0\ArcToolbox\Scripts\ExportXYV.py), only supports feature class input.

You could manipulate your output csv file using python code in a Calculate Value tool with a function embedded inside, it, for example:

expression:

fixfile(r"%Output file%")

("Output File" is a model element; note the "r" and the quotes, they are important. Make "Output file" a precondition so it will exist when the Calculate Value is run.)

Code block:

def fixfile(infile):
  # read file into a list,   
  f = open(infile,"r")
  lines = readlines(f)
  f.close()
  # for each line, delete first column, write back
  f = open(infile,"w")
  for line in lines:
    linelist = line.split(",")
    lineout = ",".join(linelist[1:])
    f.write(lineout)
  f.close()

I'm assuming there are no embedded commas in your data. That would break the script.