Hi,
I have imported a text file and am trying to break out this information
into a format I can import into a database. I basically have addresses
that can be either 3, 4, or 5 lines long. For example, here are 2
records:
ACREE JEFFREY D & REBA D
15057 LOCUST POINT
KING GEORGE VA 22485
ACREE PEARL (LIFE); ACREE DAV
JOHNNY; JUDITH & GRIFFIN LINDA
C/O JUDITH RAE ACREE
175-D ELK CREEK ROAD
MOUNT CLARE WV 26408
I need to break out the names, address, city, state, and zip. I am
assuming because of the make up of the file, I probably need to work
backwards and fill in the zip first and work my way to the name to
ensure the same type of data, ie State, goes into the same column.
My thoughts were to use transpose to send each line to a new column and
then split the cells to break out the city, state and zip, although
they may be a problem with 2 named towns like those shown above.
I was hoping for suggestions on the best way to do this before I start
torturing myself.
Thanks,
Kim
Bookmarks