remove double spaces in the string using adf expression builder

2023-12-06T10:46:52.85+00:00

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'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,131 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,326 Reputation points Microsoft Employee
    2023-12-07T18:20:02.9933333+00:00

    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.