Professional ASP.NET - Chris Love's Official Blog

Recently I had a friend tell me they were working on a project where they had to hand scrub the data in their database. In particular that day they were manually scrubbing values like 'Not Applicable', 'NA' and 'N/A' which all meant the same thing. But in order for the data to be consistent they need to go in by hand and change all these values to ...