I have a field with addresses. i want to be able to sort by street name. from what i know, i need to create two more data records one for the number part. and one for the streetname part
CURRENTLY:
Address
--------
300 NE Jefferson St.
400 S Elm St.
1213 Oak Ave.
-some addresses have two letter directions, some one, some no direction.
I need to be able to split the addressess so that i get:
Address Number Dir Street
300 NE Jefferson St. 300 NE Jefferson St
400 S Elm St. 400 S Elm St
1213 Oak Ave 1213 Oak Ave
any ideas?
CURRENTLY:
Address
--------
300 NE Jefferson St.
400 S Elm St.
1213 Oak Ave.
-some addresses have two letter directions, some one, some no direction.
I need to be able to split the addressess so that i get:
Address Number Dir Street
300 NE Jefferson St. 300 NE Jefferson St
400 S Elm St. 400 S Elm St
1213 Oak Ave 1213 Oak Ave
any ideas?