Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Regular expressions in VFP
Message
From
13/10/2008 10:31:34
 
 
To
13/10/2008 10:25:54
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01353849
Message ID:
01354585
Views:
23
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform