remove double spaces in the string using adf expression builder

Question

Hi,

remove double spaces in the column data for few of the records in the table so how can i remove it. use the below example like the below i have so many double spaces records in the column

ex: 'the product and service tags that relate the most'

Answer 1

Hi Bommisetty, Rakesh (Hudson IT Consultant),

Thank you for posting query in Microsoft Q&A Platform.

Consider using dataflows in ADF and then try to replace double spaces with empty string using derived column transformation. In derived column transformation use replace() function to do the same.

Please check below link to know more about derived column transformation.

Derived Column Transformation in Mapping Data Flow in Azure Data Factory

Hope this helps. Please let me know if any further queries. Thank you.

---

Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.