I need to split out an address string which is made up of the street number and name into several pieces:
1. Street number
2. Street direction
3. Apt number
4. Street name
Example 1: 123 NW Anywhere 345
I need '123' in the "Street Number" column, 'NW' in the "Street Direction" column, 'Anywhere' in the "Street name" column and "345" in the "Apt number" column.
I've tried splitting out the field with a space as the delimiter, but I am getting errors when I try to split the field beyond 3 because not all the address records in this file have beyond two splits.
Any ideas on how to accomplish this?