Writing Array in CSV without formatting

Hello Experts,

My input contains 2 headers. In one header, the value is in JSON format.

I am trying to write it in a CSV file but as this is in array format, I am getting below error:

Screenshot 2023-04-24 185354

I tried using .toString(), but then it negates all the quotes.
I want JSON format to be intact. Below is the format in which I want CSV to be created:

Thanks in Advance

Hi @aditya.gupta41,

Try with JSON.stringify() [JSON Stringify] function instead.

Let me know if this helps you.

BR,
Aleksandar.

2 Likes

Now it is coming as :

Require it as no \ and in single column. I think i might need to change something in CSV formatter snap.

Its done. Escape character in CSV formatter is suppose to be blank.

Thanks Aleksandar for your quick help.

1 Like