Automatically remove quotes in JSON string Java

Question

I extract data from a website in JSON format. When I try to parse a JSON with quotes in the body it gives me the following error.

org.codehaus.jettison.json.JSONException:

Does anybody know how I can automatically remove the quotes (the quotes around "Equity Put") in the string without removing the other quotes (like in "body").

In this example in the string of the body field the " in "Equity Put" gives the error.

{"body":"ChOTD-11/3/16 CBOE "Equity Put":Call Ratio / ISEE Call:Put Ratio Hits Extreme > 1.00 $SPY $SPX"}

Whoever generates that JSON string is doing it wrong. The " in the values need to be escaped as \". — Marvin
– Marvin, Commented Nov 3, 2016 at 18:50
This JSON is malformed. It's on the provider to provide well-formed JSON, and not on you as the consumer to parse malformed JSON, so whoever is providing your JSON needs to fix their output. — Compass
– Compass, Commented Nov 3, 2016 at 19:01

Mike · Accepted Answer · 2016-11-03 18:48:12Z

4

"Equity Put" should have been \"Equity Put\". Those quotes should have been what is called escaped, or otherwise, the string ends right before the word Equity.

answered Nov 3, 2016 at 18:48

Mike

2,4744 gold badges27 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jonas Cristens Over a year ago

But how do you put it in a script because this is a single object but how can I do it with multiple objects?

Mike Over a year ago

The JSON string is malformed. Whatever created that JSON string, did not do that right, or else it was changed when it was moved/converted (if any). A normal system that outputs JSON format, would have inserted the backslashes in front of the quotes inside the quoted string. You should ask the question to whoever is controlling the output, what is generating that JSON output. Perhaps it was rolled by hand and this person forgot to consider escaping quotes... String.replaceAll("\"","\\\"") might be the fix in that case. Mind you, I don't know what's going under the hood in your case.

Collectives™ on Stack Overflow

Automatically remove quotes in JSON string Java

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related