Remove special characters from csv file which is presented in azure blob storage

john 21 Reputation points
2021-05-21T04:41:05.573+00:00

i want to remove special character @ symbol present in csv file im trying with escape charater but it is not working

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

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA 90,661 Reputation points Moderator
    2021-05-21T06:14:06.437+00:00

    Hello @john ,

    Thanks for the question and using Microsoft Q&A platform.

    Use the derived column transformation to generate new columns in your data flow or to modify existing fields.

    In ADF, you can use the replace expression language to replace a substring with the specified string and return the result string.

    98497-image.png

    95169-image.png

    98435-adf-specialchar.gif

    For more details, refer Derived column transformation in mapping data flow.

    Hope this helps. Do let us know if you any further queries.

    ------------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.