How to escape JSON string for CSV parsing?

Question

A bit of an odd question perhaps.

I'm trying to Store a JSON string appropriately in a CSV column as a string. It works OK when generating the CSV file, however parsing the CSV file with the JSON in it is a problem.

I've tried "{"prop": "Val"...}", "{""prop"": ""Val""...}", "{\"prop\": \"Val\"...}", "{\""prop\"": \""Val\""...}"

However none of them parse well at all.

Please help!

I've just put "{""prop"": ""Val"",""prop2"": ""Val2""}" and it works ok. Can you show us what is the result that you are obtaining and what is the result expected? — Brank Victoria, Jul 18 '18 at 06:38
search for online csv encode/decode and it will make the job for you — Nava Polak Onik, May 10 '20 at 05:52

score 5 · Accepted Answer · answered Jul 08 '20 at 22:06

5

The correct answer here is to double quote the JSON string so this:

{ "a": 10 }

converts into this:

"{ ""a"": 10 }"

answered Jul 08 '20 at 22:06

Martin

660
10
23

score 2 · Answer 2 · answered Dec 09 '20 at 00:29

2

You can use the following replace logic to escape your JSON string:

`"${YOUR_JSON_STR.replace(/\"/g, '""')}"`

answered Dec 09 '20 at 00:29

Harry Yu

323
1
3
11

How to escape JSON string for CSV parsing?

2 Answers2