I'm already here, arrived late last night after 21 hours almost without any sleep. When will you arrive?
BTW, did you use the code sample I gave you?
>Are you going to swfox?
>Peter
>
>
>>>I have to do the opposite. we have hundreds of letters which now need to be linked to a contacts table. So I need to get the names and create the contacts if they don't exist
>>
>>And the street names are also names... quite a conundrum. If the addresses are domestic, you can look for lines containing a number, a word or two or three, and then one of "st", "cir", "la", "ln", "rd", ... then that would be the address. Also, the next line would have to be a city - list of cities can be obtained (guys who are selling zipcode data are actually selling the updates; the base data is freely available at geo survey from gov't websites), possibly followed by state and zip. So you can also check whether whatever follows the street address line is a city-state-zip, and grab that as well.
>>
>>Last time I had to do this, it was an iterative process; you grab one layer of it and see what you got and what it missed, then write the next pass. You end with something suitable for chain-of-responsibility pattern or just a long case statement.