Split alphanumeric field into two fields

MikeScott — Fri, 11 Oct 2013 13:31:02 GMT

I have an address table that has the house number and street name in the same field. I need to separate the number and text and put into 2 different fields. Any way to do in field Calculator? Examples of existing data in the single field:

1919 LAWSON RD
919 PRINCE CHARLES LN
1437-1455 PAYNE RD
407 N BRAINTREE DR

Re: Split alphanumeric field into two fields

T__WayneWhitley — Sat, 11 Dec 2021 23:08:59 GMT

...could use python's .split(' ') but then what do you plan to do with address ranges?

>>> addresses = ['1919 LAWSON RD','919 PRINCE CHARLES LN','1437-1455 PAYNE RD','407 N BRAINTREE DR']
>>> for address in addresses:
 address.split(' ')

 
['1919', 'LAWSON', 'RD']
['919', 'PRINCE', 'CHARLES', 'LN']
['1437-1455', 'PAYNE', 'RD']
['407', 'N', 'BRAINTREE', 'DR']
>>> 
>>> for address in addresses:
 address.split(' ', 1)

 
['1919', 'LAWSON RD']
['919', 'PRINCE CHARLES LN']
['1437-1455', 'PAYNE RD']
['407', 'N BRAINTREE DR']
>>>

...so if that (above) is good enough for you, then it's a single statement:

arcpy.CalculateField_management("your fc or tbl", "your num add fld", '!your orig add fld!.split(" ")[0]', "PYTHON_9.3")

...and of course for the alternate field for the remaining text, run a 2nd execution (by the way, with an updatecursor you could run a single execution to write both fields)---

arcpy.CalculateField_management("your fc or tbl", "your txt add fld", '!your orig add fld!.split(" ")[1]', "PYTHON_9.3")

topic Re: Split alphanumeric field into two fields in Python Questions

Split alphanumeric field into two fields

Re: Split alphanumeric field into two fields