Address Data Cleaning

[Keith Ratner]

Has anyone implemented any data cleaning functions? I'm looking to clean
postal address data on-the-fly, preferably using custom VBA functions in
Access.

Keith Ratner
www.skillzdesign.com

 

[Alex White MCDBA MCSE]

We need more information what do you mean by cleaning

 

[Keith Ratner]

I'm referring to function(s) to take postal addresses and standardize them
according to US (at least) Postal standards. There's a detailed
specification here: http://pe.usps.gov/text/pub28/welcome.htm

Keith Ratner
www.skillzdesign.com

 

[Keith Ratner]

I'm not necessarily looking for strict adherence to the USPS specs, just
wondering if anyone has done anything similar even on a small scale, mainly
string pattern search/replace functions to convert and standardize common
abbreviations, that sort of thing. There are versions implemented in some
commercial software already, and I think it's starting to show up in web
services, but it shouldn't be all that complicated.