Separate numbers and letters in a field for ArcGIS Pro

Summary

In ArcGIS Pro, Python expressions can be used to separate numeric and text fields from a specified text data type field with alphanumeric values. This article provides an example and instructions to create a new numeric and text field by referencing the text field with alphanumeric values using Python expressions.

The attribute table below shows the alphanumeric Name field.

Procedure

1. In the Contents pane, right-click the feature class and click Attribute Table to open the attribute table of the feature class.
2. Click Calculate to open the Calculate Field tool.

Note:
Refer to ArcGIS Pro: Calculate Field (Data Management) for more information on the parameters in the Calculate Field tool.

3. In the Calculate Field dialog box, configure the parameters.
   1. For Input Table, select the feature class. In this example, TestGrid is selected.
   2. For Field Name (Existing or New), select the field to be edited or create a new field. In this example, the NumberTestLong field is created.
   3. For Field Type, select Long (32-bit integer).
   4. For Expression Type, select Python 3.
   5. Specify the following expression in the Expression parameter. In this example, <textField> is named Name.

conv(<textField>)

6. Specify the following expression in the Code Block parameter.

def conv(<variableName>):
    <variableName1> = ''
    for chr in <variableName>:
        if (ord(chr) >= 48 and ord(chr) <= 57) or ord(chr) == 47 or ord(chr) == 32 or ord(chr) == 45:
            <variableName1> = <variableName1> + chr
    return <variableName1>

def conv(nameField):
    extractNum = ''
    for chr in nameField:
        if (ord(chr) >= 48 and ord(chr) <= 57) or ord(chr) == 47 or ord(chr) == 32 or ord(chr) == 45:
            extractNum = extractNum + chr
    return extractNum

7. Click Verify to run a test of the expression. If the expression is valid, click OK.

Note:
To display leading zeroes for the numeric field, refer to How To: Add leading zeroes to numeric fields in ArcGIS Pro for instructions.

4. In the Attribute Table, click Calculate to open the Calculate Field tool.
5. In the Calculate Field dialog box, configure the parameters.
   1. For Input Table, select the feature class. In this example, TestGrid is selected.
   2. For Field Name (Existing or New), select the field to be edited or create a new field. In this example, the AlphabetTest field is created.
   3. For Field Type, select Text.
   4. For Expression Type, select Python 3.
   5. Specify the following expression in the Expression parameter. In this example, <textField> is named Name.

conv(<textField>)

6. Specify the following expression in the Code Block parameter.

def conv(<variableName>):
    <variableName1> = ''
    for chr in <variableName>:
        if not((ord(chr) >= 48 and ord(chr) <= 57) or ord(chr) == 47 or ord(chr) == 32 or ord(chr) == 45):
            <variableName1> = <variableName1> + chr
    return <variableName1>

def conv(nameField):
    extractStr = ''
    for chr in nameField:
        if not((ord(chr) >= 48 and ord(chr) <= 57) or ord(chr) == 47 or ord(chr) == 32 or ord(chr) == 45):
            extractStr = extractStr + chr
    return extractStr

7. Click Verify to run a test of the expression. If the expression is valid, click OK.

The image below shows the new numeric and text fields added to the attribute table.