Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parsing a Street Address into Separate Fields
Message
From
18/08/2006 00:07:56
 
 
To
16/08/2006 09:43:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01144790
Message ID:
01146635
Views:
22
Glad I could help <g>

>By the way, it was MORE than a decent starting position and it was greatly appreciated!
>
>
>>Yeah. When the alternative is manual.
>>
>>The code I posted and that I could extrapolate out a 90% success rate was not including a rules engine that could possibly push this rate to 95% or more.
>>
>>Anytime that you have data that is not strictly formatted, the heuristics get complicated and there will be errors. There is no way to avoid that but you can attempt to mitigate it as best you can as the alternative, manual reconciliation, is worse.
>>
>>I'm trying to help Tracy out by giving her a decent starting position. You will note that she needs to identify every component of the address such as prefix, suffix, et al. This is not easy.
>>
>>If you think 90% is "pathetic", you are welcome to your opinion. But until you post a better alternative, in code, STFU.
>>
>>
>>
>>
>>> 90% success rate on addresses is pathetic. Is there any case where 90% success rate on parsing would be acceptable?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform