Help

Convert Table To CSV File

Résumé

Converts a table to a CSV file.

Utilisation

  • The input file can be a geodatabase table, feature class, shape file, .dbf file, or table view.

  • The output CSV file has the option to be pipe or comma delimited.

Syntaxe

ConvertTableToCsvFile_roads (in_table, out_csv_file, {in_delimiter})
ParamètreExplicationType de données
in_table

A geodatabase table, feature class, shapefile, .dbf file, or table view to convert.

Table View
out_csv_file

Location and file name of the output CSV file.

file
in_delimiter
[in_delimiter,...]
(Facultatif)

Sets the delimiter for the output CSV file (optional). The pipe delimiter is the default choice.

  • PIPE —The fields are separated by a pipe, for example, Field1 | Field2. This is the default.
  • COMMA —The fields are separated by a comma, for example, Field1, Field2.
String

Exemple de code

ConvertTableToCsvFile example (in-line)

The following Python window script demonstrates how to use the ConvertTabletoCSV function in the immediate mode.

# tool variables
in_table="SpeedLimit"
out_csv_file="SpeedLimit_Converted"
in_delimiter="COMMA"

# set current workspace
arcpy.env.workspace="C:/Transportation.gdb"

# Process: Convert Table To CSV File
arcpy.ConvertTableToCsvFile_roads("SpeedLimit", "SpeedLimit_Converted", "COMMA")
ConvertTableToCsvFile example (Stand Alone script)

The following Python window script demonstrates how to use the ConvertTabletoCSV function in a stand-alone python script.

# Name: TableToCSV.py
# Description: Converts a table to a CSV file. 
# Requires: Esri Roads and Highways Solution

# Import arcpy module
import arcpy

# Check out any necessary licenses
arcpy.CheckOutExtension("Highways")

# Process: Convert Table To CSV File
arcpy.ConvertTableToCsvFile_roads(r"C:\Transportation.gdb\SpeedLimit", r"C:\Data\SpeedLimit_Coverted", "COMMA")

Environnements

Informations de licence

  • ArcGIS for Desktop Basic: Requiert Roads and Highways
  • ArcGIS for Desktop Standard: Requiert Roads and Highways
  • ArcGIS for Desktop Advanced: Requiert Roads and Highways

Rubriques connexes