Is there a way to parse a street address in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
MPD said:
If there is, could you give me the steps involved.
Click to expand...


Parsing requires an unambiguous set of rules that detail how
to identify the various parts of an address. If you have a
nicely restricted set of addresses to operate on, it can
probably be done (once you explain the rules), but, in
general, there is no such set of rules for either
people/place names or addresses.
 
MPD said:
If there is, could you give me the steps involved.
Click to expand...

MPD, there is no easy calculation steps involved to parse a mailing address.
There are many industry standard software that do this ($,$$$), but the ones
that do it correctly rely not only on recognition, but on the USPS (Postal
Service) address database. And of course, this is not static and relies on
regular updates. That is talking in general terms. However if your addresses
follow some sort of pattern and are not to crazy or globalized, there may be
an easier approach you can take. Just come back to us with some samples and
we may be able to come up with a handy, but not industry-strength solution.

-Randy
 
If there is, could you give me the steps involved.
Click to expand...

Yes and no. As Randy and Marshall say, it's not that easy! I've got
the following addresses (or trivial modifications for privacy) in my
address book:

408 West Central Ave.
406 West Central
1812 1/2 S. Utica
33205 Old Fort Boise
Ballacraine

They're all recognized by the USPS.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top