Data scrubbing also called data cleansing, is the process of amending or removing incorrect data in a database. Sometimes data incomplete, improperly formatted like postal code should be in this format “N9B 1W7″ not in “N9B1W7″or first name and last name in 1 field, instead separate fields or duplicated.

Sometimes zip codes are missing or in one case we found data was separated using incorrect SQL functions resulting in erroneous data. Data scrubbing / cleansing a dirty data is always different in different companies.

We have a successfully accomplished various complicated tasks using various tools and SQL language.