cmckinn63

Split alphanumeric field into two fields

Discussion created by cmckinn63 on Oct 11, 2013
Latest reply on Oct 11, 2013 by Wayne_Whitley
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

Outcomes