Custom cleaning text using DQS Cleansing component


  • I am using DQS for the first time and I am using the DQS Cleansing component in my SSIS package. How do I do this -

    1. Replace all white spaces/extra spaces in my text with just one single space. I don't want to use the 'Normalize String' option.
    2. Remove certain words like 'and', etc.
    3. Replace commas by single white space.

    So I'd want 3 and 2 to run first since they would create spaces and then run 1.

    Any ideas on how to accomplish this using DQS Cleaning?

    Thanks in advance.

    Tuesday, August 13, 2013 6:04 PM