Problem: I have an address field from an Access database which has been converted to Sql Server 2005. This field has everything all in one field. I need to parse out the individual sections of the address into their appropriate fields in a normalized table. I need to do this for approximately 4,000 records and it needs to be repeatable. ...
What is the "best" way to store international addresses in a database? Answer in the form of a schema and an explanation of the reasons why you chose to normalize (or not) the way you did. Also explain why you chose the type and length of each field. Note: You decide what fields you think are necessary. ...
How do I find duplicate addresses in a database, or better stop people already when filling in the form ? I guess the earlier the better? Is there any good way of abstracting street, postal code etc so that typos and simple attempts to get 2 registrations can be detected? like: Quellenstrasse 66/11 Quellenstr. 66a-11 I'm talking Ge...
I need to take a web page and extract the address information from the page. Some are easier than others. I'm looking for a firefox plugin, windows app, or VB.NET code that will help me get this done. Ideally I would like to have a web page on our admin (ASP.NET/VB.NET) where you enter a URL and it scraps the page and returns a Dataset ...
I'm looking for a common pattern that will store and access global addresses in database. Components or other technologies can be used. The following criteria must be adheard to... Every line of the address is saved for every country Postal codes are tested with a regular expression before being saved Country of original is saved in ...
How would I go about converting an address or city to a latitude/longitude? Are there commercial outfits I can "rent" this service from? This would be used in a commercial desktop application on a Windows PC with fulltime internet access. ...
How do you model your customer address data and what techinques are you using to ensure the quality of the data? Things like deduplication algorithms, duplicate matches, making sure that packages and invoices can actually be delived and such? Esepcially in systems handling customers in multiple countries. ...
At about 24:20 in Stack Overflow Podcast 26 Joel Spolsky said there are services that mail postcards with codes for address verification. Spolsky: You know what we could have badges for? We could have badges for like: "Real Address". Like I have proven that you live at a certain address. Atwood: We could. Spolsky:...
I need to write an algorithm that returns the closest match for a contact based on the name and address entered by the user. Both of these are troubling, since there are so many ways to enter a company name and address, for instance: Company A, 123 Any Street Suite 200, Anytown, AK 99012 Comp. A, 123 Any St., Suite 200, Anytown, AK 9901...
Q. I have a hex code running on a machine. How do I calculate the checksum of the entire code at runtime? ...
Somewhat related to this question, but in the absence of any answer about QuickBooks specifically, does anyone knows of an address parser for Java. Something that can take unstructured address information and parse out the address line 1, 2 and city state postal code and country? ...
I'm working on a shopping cart that needs to calculate tax rates based on the ship-to county. I don't want to ask the customer for the county but instead I'd like to look up the county by using the address they provided. And to top it off, this should be free. So, does a [free] service like this exist? I couldn't find anything via UPS ...