Parsing JSON string in CSV

Aspose.Cells Product Family
1

Hi,
I would like to parse the following CSV.

“Number”;“JSON”;“Checked”
“1”;"{“count”:“1”}";“true”
“2”,"{“count”:“2”}" ;“false”

Please let me know the CSV load options to be set. I want to set semicolon as delimiter. What will happen if the value in JSON itself contains semicolon. How to escape that?

2

@beekay,

Thanks for your query.

I am afraid it is not supported, i.e., parsing JSON while importing CSV files. Well, you may parse the JSON data by yourself (to render some file) using your own code. You can also then implement ICustomParser while using it with TxtLoadOptions, see the document with example code for your reference:

Hope, this helps a bit.