ParseFieldName (arcpy)

Summary

Parses a fully qualified field name into its components (database, owner name, table name, and field name) depending on the workspace. ParseFieldName returns a string containing the parsed table name, containing the database, owner, table, and field names separated by commas. The workspace must be a personal, file, or ArcSDE geodatabase.

Syntax

ParseFieldName (name, {workspace})
ParameterExplanationData Type
name

The field name to be parsed.

String
workspace

Specifies the workspace for fully qualifying the field name. The workspace must be a personal, file, or ArcSDE geodatabase.

String
Return Value
Data TypeExplanation
String

Returns the field name parsed into its components (database name, owner name, table name, field name) separated by commas.

Code Sample

ParseFieldName example

Parse a field name into its components.

import arcpy

field_name = arcpy.GetParameterAsText(0)
workspace = arcpy.GetParameterAsText(1)

# Parse the field name into database, owner, table and field
fullname = arcpy.ParseFieldName(field_name, workspace)
database, owner, table, field = fullname.split(", ")

Related Topics

3/3/2014