How can we trim bad data and output clean trimmed data using DQS or MDS? Until now, we have used stored procedures for data massaging and cleansing but we have now decided to move to using Data Quality Services (DQS) and Master Data Management (MDS) in our data warehouse projects.

There is one very common function which we use in our stored procedures - it trims and replaces the , character with white space e.g.: 

UPDATE [Table] SET Column=(ltrim(rtrim(replace(Column,',',''))))


I have spent hours to figure out a way to achieve this using DQS and MDM but couldn't find any way to achieve the same goal.

I would really appreciate if you guys can help me out with this.
In fact, thank you already for your precious time.
I think if you can use SQL Server 2017, this new function Trim() Can help you write it better. if you insist on using DQS for this matter, I think this article can help you find your way. Sorry that I couldn't write it for you. Hope it helps.