I have a membership web application. But we have a problem with duplicate member records with slightly different mailing addresses entered for the same person. Anyone know of a way that my app can use some web service to standardize U.S. addresses and add the Zip+4 code?
People can do it manually via http://www.usps.com/zip4/, but I want the application to do it seamlessly. I want the user to input an address. Then before inserting it into the database, I want the script to standarize the mailing address.
Apparently, USPS offers this service on the web, but it's only if you agree to use it for shipping packages (like on an ecommerce site). But mine won't be for that purpose. So does anybody know of an alternative?
