How to remove escape character '//' in the output file of the JSON sink dataset
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.