Improved Address edit

[Bob Stockler]

Walter Vaughan wrote (on Mon, Jul 07, 2008 at 10:36:52AM -0400):

| GCC Consulting wrote:
| 
| >I am in need of a improved address edit that uses the uplow edit 
| >except when you have a direction such as NE,SE,NW,SW.  The directions 
| >need to be upper case.
| >
| >Alan Mazuti
| >
| >Try lowup instead.
| >
| What the cool kids would do would be to take a US address, submit it to 
| the USPS API, and store that result.
| Why even guess as to how you should properly format the address. People 
| don't know hardly know where
| they live anymore anyways.

Bob Snapp once wrote an Address Matching / Address Correction program
in filePro, which I used.  It was fantastic.  Monthly he'd get tapes
containing their data base from the USPS, converting them into the
data files his filePro program used.  I don't think any filePro users
bought it from him, though his program was so much better than the one
the USPS used - they hired him as a consultant!

I believe that having addresses in a consistant format is one of the
best ways to prevent duplicate entries in a database, so I use a USER
program that passes an entered address through an AWK program I wrote
to assure consistancy.  If an address already in the database is again
entered, the operator is questioned whether or not it is a duplicate.

Bob

-- 
Bob Stockler +-+ bob at trebor.iglou.com +-+ http://members.iglou.com/trebor