Hi Terry,
I have this application written for our system. I can probably send you the parsing method, if you're interested and couple of screen shots of this application.
>Hello,
>
>I am in the process of converting an address in a table. The address currently is broken down into address, city , state, zip fields. I need to parse the address portion into separate street number, direction, street name, suffix, etc., fields. For example:
>
>123 N. Any Street --- needs to be parsed into 123---N.---Any---Street
>456 East Smith Dr. --- needs to be parsed into 456---East---Smith---Dr.
>
>Are there any classes or programs out there that have done this kind of work? Due to the inconsistent data input of directions and street suffixs, this gets kink of messy. Add a few apartment numbers or suites, and it gets really interesting!
If it's not broken, fix it until it is.
My Blog