I am working on a project for which I would like join fields using addresses. I have an excel file with all address information in one field, and attribute data that has the address information seperated. Can anyone think of a way to join these two fields without having to manually enter each address into one or the other databases?
123 Main Street Anywhere USA
123 Main Street Anywhere, USA(Consider the spaces to be seperate fields)
At this point I am ready to start manually editing the attribute table with the appropriate information from the excel file.
Edited by Hans van der Maarel, 18 November 2008 - 02:01 PM.
changed formatting a bit