Summary
Adds field delimiters to a field name for use in SQL queries.
Legacy:
This is a legacy function. Field delimiters are not needed for SQL queries in ArcGIS Pro.
Syntax
AddFieldDelimiters (datasource, field)
Parameter | Explanation | Data Type |
datasource | The data source used to determine the field delimiters. | String |
field | The field name to which delimiters will be added. The field does not have to currently exist. | String |
Data Type | Explanation |
String | The delimited field name. |
Code sample
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),
state_value)
# Use delimited field for Select tool SQL expression
arcpy.analysis.Select(in_features, out_feat_class, sql_exp)