Finding value in json string

Question

Below is what I have as JSON String.

{
    "ID_A0001":{"areaID":"A0001","shopID":"SH004","quantity":14},
    "ROW_INFO":{"areaID":"VARCHAR","shopID":"VARCHAR","quantity":"INT"},
    "ID_A0002":{"areaID":"A0002","shopID":"SH008","quantity":18}
}

What I want is to get the JSONObject which have ID as ID_A i.e. ID_A0001 & ID_A0002.

I was thinking of using jsonObject.getString("ID_A"), but that is not possible. Could someone tell me what should I do so that I will get as below output.

{
    "ID_A0001":{"areaID":"A0001","shopID":"SH004","quantity":14},
    "ID_A0002":{"areaID":"A0002","shopID":"SH008","quantity":18}
}

ThiefMaster · Accepted Answer · 2012-06-05 11:53:40Z

4

The following code does what you want, assuming the object you posted is stored in obj. In case you actually have a JSON string instead of an object, use JSON.parse() to convert the string to a JavaScript object.

var obj2 = {};
for(var key in obj) {
    if(key.substr(0, 4) == 'ID_A') {
        obj2[key] = obj[key];
    }
}

answered Jun 5, 2012 at 11:53

ThiefMaster

320k85 gold badges608 silver badges648 bronze badges

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

Comments

Paras · Accepted Answer · 2012-06-05 12:08:43Z

2

In the json object you have mentioned, you can modifiy it as follows.

 var jsontest={
    ID_A0001:{"areaID":"A0001","shopID":"SH004","quantity":14},
    ROW_INFO:{"areaID":"VARCHAR","shopID":"VARCHAR","quantity":"INT"},
    ID_A0002:{"areaID":"A0002","shopID":"SH008","quantity":18}
        };

for(var key in jsontest) {
    if(key.substring(0,4)=='ID_A')
    alert('key: ' + key + '\n' + 'value: ' + jsontest[key].areaID);
}

http://jsfiddle.net/FBLvP/

Here is a useful link which shows us how to get the list of keys from a json object http://encosia.com/using-jquery-1-6-to-find-an-array-of-an-objects-keys/1

answered Jun 5, 2012 at 12:08

Paras

3,1078 gold badges37 silver badges46 bronze badges

Collectives™ on Stack Overflow

Finding value in json string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related