How to remove escape character '//' in the output file of the JSON sink dataset

Kien Nguyen Mai Tuan 0 Reputation points
2024-11-19T10:23:15.6066667+00:00

Good day community,

I'm seeking your help in removing the escape character \ from the output of the dataflow with JSON as the sink dataset. The objective is to produce a JSON output file with a row containing the value: ["all.be"]

In the Derived column activity, if I create a new column called Code and in the Expression of the column, I would put the value as ["all.be"]. This results in the JSON output file is "["all.es"]" even though when I turned the debug mode on, the output would be just ["all.be"]. I have tried adding the replace function in the expression to replace '\' to ''. but there is no escape character \ to be replaced until the actual writing of output into a JSON file

Could you let me know what I can do to remove the escaped character and if possible how to remove the quoted character" " outside of brackets [] please?

Thank you and much appreciated for your time looking into the problem.

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

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.