#1
  1. Inherits Programmer.Slacker
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Aug 2003
    Location
    Between my Id and your Ego
    Posts
    2,351
    Rep Power
    726

    Address Standardization


    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?
    Fisherman

    "Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,207
    Rep Power
    4279
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. Inherits Programmer.Slacker
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Aug 2003
    Location
    Between my Id and your Ego
    Posts
    2,351
    Rep Power
    726
    Originally Posted by r397
    if you're doing this yourself, use 6 address lines
    Greatest common factor?
    Fisherman

    "Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,207
    Rep Power
    4279
    yeah, something like that

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    1
    Rep Power
    0
    hey there,
    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.....
    cheers,
    harry.

IMN logo majestic logo threadwatch logo seochat tools logo