AddFieldDelimiters

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)
ParameterExplanationData 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
Return Value
Data TypeExplanation
String

The 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),
    state_value)

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

Related topics