Steve,


>Does anyone have any examples of address parsing routines?
>
>I have a client whose City State ZIP line is an absolute mess and rather than have them hand code all the changes, I was wondering if the Fox World would have a better way.
>
>Thanks in advance.

Well, there are companies out there that can do this for you. They are CASS (Coding Accuracy Support System) certified. That is, the USPS (US Postal Service) has certified that they do addresses in the manner that the USPS would like. You give them your data and pay their fee. They send your data back all cleaned up. This is the quickest and easiest way to go - but it costs.

The other way is to write your own. Using somone else's routines can help but will more than likely not be as closely you will need as this kind of data is often, as you say, a mess.

Cost..

Well, you can either spend the dollars using someone else's routines or spend the dollars taking the time to write your own.

Here's the link to the USPS main page: http://www.usps.gov/

Here is the link to the USPS technical CASS guides: http://new.usps.com/cgi-bin/uspsbv/scripts/content.jsp

That should give you all the information you could ever want. <g>