Convert Table To CSV File (Roads and Highways)

Summary

Converts a table to a CSV file.

Usage

• 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.

Syntax

ConvertTableToCsvFile_roads (in_table, out_csv_file, {in_delimiter})

Parameter	Explanation	Data Type
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,...] (Optional)	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

Code Sample

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")

Environments

Current Workspace

Licensing Information

ArcGIS for Desktop Basic: Requires Roads and Highways

ArcGIS for Desktop Standard: Requires Roads and Highways

ArcGIS for Desktop Advanced: Requires Roads and Highways