Data Cleanser
Published 16 April 2015
Data Cleanser is a Business Intelligence Development Studio component you can use to standardize data that may contain inconsistencies. You can only use Data Cleanser on strings.
Data Cleanser has been archived, but you can still download it from from Red Gate Labs.