Share via

Removing \n and \r from json file and copying it in another blob as a csv file using copy data activity in azure data factory

K Megha 1 Reputation point
2022-06-11T13:56:00.907+00:00

Hi I have a json file with \r and \n characters in the values in some of the fields. I want to ignore
them and copy into csv file in the separate folder in blob using copy activity using azure data factory. Can you please help me to ignore these carriage return in the file in azure data factory

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Pratik Somaiya 4,211 Reputation points Volunteer Moderator
    2022-06-11T18:24:01.42+00:00

    Hello @K Megha

    A similar kind of implementation has been done in this article

    Can you check this resolution and try similar approach, in the article, function app's output is fed as input to set variable activity

    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.