Adding two json objects and sorting

Question

I have got three similar json objects. Now i wish to join the entire list and then sort the complete list according to one of the index. Here, goes the objects description

Object 1

[{"link":"#","prod":"Fundamentals Of Software Engineering","price":" Rs. 200 "},{"link":"##","prod":"Real-Time Systems: Theory And Practice","price":" Rs. 394 "}]

Object 2

[{"link":"#","prod":"Fundamentals Of Software Engineering","price":" Rs. 200 "},{"link":"##","prod":"Real-Time Systems: Theory And Practice","price":" Rs. 394 "}]

Object 3

[{"link":"#","prod":"Fundamentals Of Software Engineering","price":" Rs. 200 "},{"link":"##","prod":"Real-Time Systems: Theory And Practice","price":" Rs. 394 "}]

Once, I join all of them , I wish to sort the complete array (new one) w.r.t to price index.

Any hint for this will be appreciated. thanks :)

Where are you stuck? How to parse JSON, how to concatenate arrays, how to sort an array of objects or something else? — Felix Kling
– Felix Kling, Commented Jan 15, 2012 at 10:53
Then follow the link in my comment. FYI, if you have already parsed the JSON into JavaScript objects/arrays, then your question is not related to JSON anymore. — Felix Kling
– Felix Kling, Commented Jan 15, 2012 at 10:54
What is more preferrable, to concat JSON object or to javascript object ? — Prashant Singh
– Prashant Singh, Commented Jan 15, 2012 at 11:10

Diode · Accepted Answer · 2012-01-15 12:00:24Z

2

if Object1 , Object2 and Object3 are JSON strings convert it to Javascript objects using eval function.

Then merge them using concat method. http://www.w3schools.com/jsref/jsref_concat_array.asp

var mergedArray = arr1.concat(arr2, arr3);

Then sort using sort method in Javascript Array. ref : http://www.w3schools.com/jsref/jsref_sort.asp ref: https://developer.mozilla.org/en/JavaScript/Reference/Global_Objects/Array/sort

var sorted = mergedArray.sort(function(a, b){

    // This function is used by sort method for sorting process
    // This function gets called with parameters a,b which are the elements in array (here product objects from your JSON)
    // if this function returns value < 0 a is placed before b
    // if this function returns 0 nothing is changed
    // if this function returns value > 0 b is placed before a
    // a.price.replace("Rs.", "") removes Rs. from price string. so "Rs. 200" becomes 200
    // parseFloat(a.price.replace("Rs.", "")) makes it number.  "200" becomes 200. "200.50" becomes 200.5
    // priceA - priceB returns -ve value if priceA < priceB, 0 if priceA = priceB, +ve value if priceA > priceB.

    var priceA = parseFloat(a.price.replace("Rs.", ""));
    var priceB = parseFloat(b.price.replace("Rs.", ""));
    return priceA - priceB;



});

Use return priceB - priceA; for descending order. jsfiddle : http://jsfiddle.net/diode/FzzHz/

.

edited Jan 15, 2012 at 12:00

answered Jan 15, 2012 at 11:26

Diode

25.2k8 gold badges43 silver badges52 bronze badges

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

2 Comments

Prashant Singh Over a year ago

can you please explain the last part? After merging array, I am not getting how this code sorts them. Please explain a bit

Prashant Singh Over a year ago

Thanks a lot. I got everything :D

Community · Accepted Answer · 2017-05-23 12:14:04Z

1

Convert them to object and this should do the trick

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Jan 15, 2012 at 10:53

ladar

5,8864 gold badges29 silver badges39 bronze badges

Comments

Darin Dimitrov · Accepted Answer · 2012-01-15 11:00:30Z

1

You could use the concat method to concatenate the arrays:

var result = arr1.concat(arr2, arr3);

and then you could sort the resulting array.

Let's write the sort function that will sort them using the prod property (you could sort them by any property you wish):

function SortByProd(a, b) {
    var aProd = a.prod.toLowerCase();
    var bProd = b.prod.toLowerCase(); 
    return ((aProd < bProd) ? -1 : ((aProd > bProd) ? 1 : 0));
}

and then sort:

result.sort(SortByProd);

edited Jan 15, 2012 at 11:00

answered Jan 15, 2012 at 10:55

Darin Dimitrov

1.0m277 gold badges3.3k silver badges3k bronze badges

Collectives™ on Stack Overflow

Adding two json objects and sorting

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related