Parsing data in json using java

Question

I have to parse the following data

{"ResultSet":{"Query":"microsec fin","Result": [{"symbol":"MICROSE_a.NS","name": "MICROSEC FIN SERV LTD ","exch": "NSI","type": "S","exchDisp":"NSE","typeDisp":"Equity"}, {"symbol":"MICROSEC.NS","name": "Microsec Fin Serv Ltd","exch": "NSI","type": "S","exchDisp":"NSE","typeDisp":"Equity"}]}}

The code i am using is

JSONObject json = (JSONObject) JSONSerializer.toJSON(inputLine); symbol=json.getJSONObject("ResultSet").getJSONArray("Result").getJSONObject(0).getString("symbol");

which returns MICROSE_a.NS. What i want to do is if there is an undersore in symbol then i want the next symbol to be taken. That is now i want symbol to actually hold MICROSEC.NS. How do i do this.

Simply reiterate through the JSON object and pick first item. If item has underscore, pick the next using a flag. — Straseus
– Straseus, Commented Mar 29, 2012 at 11:41
You'll have to check the current symbol for _ and then select the next symbol using the same statement. You could probably put this in a loop. — Chetter Hummin
– Chetter Hummin, Commented Mar 29, 2012 at 11:43
Could you please post some code as im a little confused right now. — user1092042
– user1092042, Commented Mar 29, 2012 at 11:43

anvarik · Accepted Answer · 2012-03-29 12:27:32Z

Or which is much simpler with your library:

JSONArray Result= json.getJSONObject("ResultSet").getJSONArray("Result"); for(int i = 0; i<Result.length(); i++){ String symbol = Result.getJSONObject(i).getString("Symbol"); if(!symbol.contains("_")) return symbol; }

Collectives™ on Stack Overflow

Parsing data in json using java

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related