how do convert json string to a string

Question

I have the json string from MySQL database:

{"teams":[{"sport":"NFL"},{"sport":"NBA"},{"sport":"NCAA Football"},{"sport":"NCAA Men Basketball"}],"success":1}

And I need to convert this string to the following format:

 final String sports[] = {"NFL", "NBA", "NCAA Football", "NCAA Men Basketball"};

Any ideas how to do this?

a trick would be to use a regex like this : "sport":"([A-Za-z\s]*)" the capture group is exactly the sport word — Dan Ionescu
– Dan Ionescu, Commented Feb 25, 2017 at 17:51
Take a look at jq, it is a general parser/editor for json and can be utilized for all manner of json transformations. — Greg Tarsa
– Greg Tarsa, Commented Feb 25, 2017 at 17:55

mahiraj2709 · Accepted Answer · 2017-02-26 03:30:00Z

1

import org.json.*;
String jsonString = yourJsonStringFromDatabase;
JSONObject obj = new JSONObject(jsonString);

JSONArray team = obj.getJSONArray("teams");
String[] sports = new String[team.length());
for (int i = 0; i < team.length(); i++)
{
    sports[i] = arr.getJSONObject(i).getString("sport");
}

edited Feb 26, 2017 at 3:30

answered Feb 25, 2017 at 17:55

mahiraj2709

714 bronze badges

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

Collectives™ on Stack Overflow

how do convert json string to a string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related