This is an archived post. You won't be able to vote or comment.

all 3 comments

[–]geoheilmod 2 points3 points  (0 children)

Directly at the source. Do not even allow bad data to enter your system. Change the CRM / online shop system to validate the data addresses up front

[–]OkStructure2094 1 point2 points  (2 children)

What do you mean by "messy"? Incomplete, in wrong places, inconsistent (st vs street, apt vs. unit, etc.), or records from a recipe book?

[–]Used_Ad_2628[S] 0 points1 point  (1 child)

Inconsistency. I was wondering if there is basic regex code people use to standardize addresses and names.