I do not envy you, Steve. Names alone will have you tearing your hair out. I guess if I faced this problem I would use a program to parse the vast majority of simple cases and then deal with the remaining ones manually. I doubt there is a silver bullet so the question becomes which is the least painful alternative. Personally I don't mind a certain amount of scut work as long as there is music to distract me.

>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.