Breaking News: Grepper is joining You.com. Read the official announcement!

There is no space in KETHN0FT035600000021000000 so the script should split the code on the sixth string of the code

tendai dupwa answered on August 31, 2023 Popularity 1/10 Helpfulness 1/10

answer There is no space in KETHN0FT035600000021000000 so the script should split the code on the sixth string of the code

There is no space in KETHN0FT035600000021000000 so the script should split the code on the sixth string of the code

Comment

import arcpy

# Path to your feature class
feature_class = r"C:\Path\to\Your\FeatureClass"

# Name of the field containing SG code information
sg_code_field = "SGCodeField"

# Name of the new "SG Code Prefix" field
sg_code_prefix_field = "SGCodePrefix"

# Name of the new "SG Code Number" field
sg_code_number_field = "SGCodeNumber"

# Position to split the SG code
split_position = 6

try:
    # Check if the SG code field exists in the feature class
    if arcpy.ListFields(feature_class, sg_code_field):
        # Add the new fields if they don't exist
        if not arcpy.ListFields(feature_class, sg_code_prefix_field):
            arcpy.AddField_management(feature_class, sg_code_prefix_field, "TEXT")
        if not arcpy.ListFields(feature_class, sg_code_number_field):
            arcpy.AddField_management(feature_class, sg_code_number_field, "TEXT")

        # Update cursor to iterate through features
        with arcpy.da.UpdateCursor(feature_class, [sg_code_field, sg_code_prefix_field, sg_code_number_field]) as cursor:
            for row in cursor:
                sg_code_value = row[0]
                sg_code_prefix = sg_code_value[:split_position]
                sg_code_number = sg_code_value[split_position:]

                # Update the new fields
                row[1] = sg_code_prefix
                row[2] = sg_code_number
                cursor.updateRow(row)

        print("Fields 'SG Code Prefix' and 'SG Code Number' added and values updated.")

    else:
        print(f"Field '{sg_code_field}' not found in the feature class.")

except Exception as e:
    print(f"An error occurred: {str(e)}")

Popularity 1/10 Helpfulness 1/10 Language python

Source: chat.openai.com

Tags: python script space string

Link to this answer
Share Copy Link

Contributed on Aug 31 2023

tendai dupwa

0 Answers Avg Quality 2/10

There is no space in KETHN0FT035600000021000000 so the script should split the code on the sixth string of the code

Contents

More Related Answers

There is no space in KETHN0FT035600000021000000 so the script should split the code on the sixth string of the code

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.