DQS not removing special characters

i using dqs , have domain checked box 'normalize string' , give output in form of lower case characters. but when run file against domain output contains lower case characters special characters comma, forward slash still there. anything wrong doing? thanks in advance.

hello,

when select normalize string check box, dqs ignores special characters in source value. dqs internally replaces special characters either null or space ensure better string comparison data quality processing. these internal replacements of special characters not have impact on processed or output data.

if want find out special characters in source data, use regular expresssions in domain rule flag values containing special characters, , clean them interactively using dqs. example, can use following domain rule flag values contain special character or spaces between 2 words in value:

value matches regular expression = ^[a-za-z0-9]+([\s][a-za-z0-9]+)*$

this flag values special characters invalid, and you can cleanse these values in manage , view results page in cleansing data quality project in dqs. more information, see article: using dqs: how find special characters , spaces between words in data.

thanks
vivek
(sql server documentation | twitter: @vivek_msft)

---

note: please remember appropriately vote post "helpful" or mark "answer" community.

---

SQL Server  >  SQL Server Data Quality Services