>Does anyone have a good (preferably free or low cost) address parser to recommend? I have a file full of manually entered addresses, in one field, that I need to break out to its respective parts.
>
>Example:
>
>"123 Cherry Bluff Ln Box 311 Any Town, CO 12345"
>
>The address may have an address2 part or just the first address. The zip may be 5 or 9 digits.

http://www.softwarecompany.com/activex/activeaddress.htm
http://smartystreets.com/products/liveaddress-lists

..but I haven't used either. You might check the USPS I'm sure they have an API you can use. I suppose it all depends on how many addresses are in the list, if this is a one-time thing, or you expect to have to deal with this on a regular basis. I know there is a UPS API (which I did use with a VFP app a few years ago) - but it didn't deal with p.o. boxes or any other address that UPS didn't deliver too. In my case that was ok because everything was shipping out via UPS.