JSON Parse error

[Hong_Hu]

Hi  all, 

My JSON Parse is producing an error:  "Missing a comma or '}' after an object member."

The cell I'm trying to parse is of this format:

{"Title 1":"text", "Title 2":"Text A:Text B"}

I think the problem is in the second part, where I have a ":" in the text.

What should I do in this case? Thanks for any advise!

Best,

Hong

[apathetichell]

If the objects are wrappd in quotes - that should not be an issue. 

[Hong_Hu]

Thanks! I did more digging and it appears that the real issue is that I have data like {"Title":"text ""A"" text B", "Title2":"xxx etc."} (double quotation inside the text). I will need to clean it up. thanks!

[apathetichell]

Now that's a prolem... you'll either need to use a json escape character (/") or single quotes. and for collections you should use:

["value1","value2",..."valueN"]