I have bunch of home adresses which contain home number and subnumber, for example Street of J.F. Kennedy 1005A. Now I want to split this into two fields out of home number, one for main number and one for subnumber.
How to split '1005A' and get '1005' in one and 'A' in another field somehow using the 'split command' in Field Calculator?
You can do this using Python code and the UpdateCursor which is like a more powerful Field Calculator. The re module is doing the splitting of the numbers and letters.
Add the Feature Class to ArcMap, add the two fields as text (or modify the code to convert into other data types) and execute code in the Python Window. You need to change name of the feature class and fields in the code to match your data (yellow below):
import arcpy,re
fieldlist=['Adress','Main_number','Subnumber']
with arcpy.da.UpdateCursor("Points123",fieldlist) as cursor:
for row in cursor:
row[1],row[2]=re.findall(r'[A-Za-z]+|\d+', row[0].split()[-1])
cursor.updateRow(row)
