I need to split the values in a field according to what they represent to be able to do a join on the data.
As seen above I have a ID field that needs to be split into the following:
The ID consist of 21 digits where the first 8 digits represents the Town Code
The next 8 digits represents the ERF number
The last 5 digits represents the Portion number.
In there a way to easily split these into their own fields as I need to join a excel sheet to Town number, ERF and Portion.
For example:
C04100030000194800000
Will be split into their own fields:
TOWN: C0410003
ERF: 00001948
PORTION: 00000
I assume that this will be done with arcpy as I have over 50 000 records?
Any help will be greatly appreciated.
Aucun commentaire:
Enregistrer un commentaire