How to convert String to Json Object in java or groovy

Question

I saved a json into the database as a string like this:

"[_district:_1_2_5village, _name:_1_1_2id_inter, _gender:_1_3_5sex]"

Now i want to convert it back to a Json Object so as to pick the key and value eg _district is the key and _1_2_5village is the value. Any help on how i can achieve this. Thanks

I tried to convert the string back into JSON by parsing but that dint work for me.

json should look like this: { "_district": "_1_2_5village", "_name": "_1_1_2id_inter", "_gender": "_1_3_5sex" } — daggett
– daggett, Commented Nov 4, 2022 at 8:33
If you're saving invalid text into the database, you probably want to start with fixing that, instead of writing a custom parser — tim_yates
– tim_yates, Commented Nov 4, 2022 at 11:55

Teddy Tsai · Accepted Answer · 2022-11-04 08:14:23Z

1

It doesn't work because that's not a JSON format, a JSON is a way of mapping objects and uses key value syntax like so:

{"key": "value"}

and an array would look like this:

[{"key": "value"},{"key": "value"}]

You'll need to make a custom parser for your syntax

Here's the json specification:

https://www.json.org/json-en.html

answered Nov 4, 2022 at 8:14

Teddy Tsai

6264 silver badges22 bronze badges

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

1 Comment

Crispus3 Over a year ago

Thanks for the response, Teddy. I fixed the format to save a JSON.

Collectives™ on Stack Overflow

How to convert String to Json Object in java or groovy

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related