June 19th, 2006, 11:32 PM
Ok...I'm sick of this.
I'm migrating data from three (third-party, propietary) systems that my company has been using into one common system. The problem with this is that address information in these systems is about as standardized as a bag of rocks. One product simply has 6 address lines, and does not segregate the information (city, state, zip, etc...). Another one has dedicated lines, but users have taken it upon themselves to "invent" ways to enter data (international customers/vendors have data in weird fields, but no rhyme, reason, or cohesion to the madness). The third one is just as bad.
I'm looking for a script-based, SQL implemenation (stored procedures?) for standardizing the addresses into a common format. Does anyone know of anything?
June 20th, 2006, 06:35 AM
if you're doing this yourself, use 6 address lines
you can also purchase software for this purpose, but i don't have first-hand experience with any
June 20th, 2006, 08:24 AM
Greatest common factor?
Originally Posted by r397
June 20th, 2006, 08:35 AM
yeah, something like that
did you have any success getting sql stored procedures to do the address standardization/matching?
even a set of rules would get me started and i could build one myself.....