AddFieldDelimiters (arcpy)

Summary

Adds field delimiters to a field name to allow for use in SQL expressions.

Syntax

AddFieldDelimiters (datasource, field)

Parameter	Explanation	Data Type
datasource	The field delimiters are based on the data source used.	String
field	The field name to which delimiters will be added. The field does not have to currently exist.	String

Return Value

Data Type	Explanation
String	Returns a delimited field name.

Code Sample

AddFieldDelimiters example

import arcpy

field_name = arcpy.GetParameterAsText(0)
arcpy.env.workspace = arcpy.GetParameterAsText(1)
in_features = arcpy.GetParameterAsText(2)
out_feat_class = arcpy.GetParameterAsText(3)
state_value = arcpy.GetParameterAsText(4)

# AddFieldDelimiters will return a field name with the proper
#  field delimiters for the workspace specified.
#
sql_exp = """{0} = {1}""".format(
    arcpy.AddFieldDelimiters('c:/data', field_name),
    field_name)

# Use delimited field for Select tool SQL expression
#
arcpy.Select_analysis(in_features, out_feat_class, sql_exp)