Combining and organizing two JSON objects

Question

Combining and organizing two JSON objects

I have three JSON objects that are similar. I want to combine all of them into one list and then sort the entire list based on a specific index value. Here is the description of the objects:

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 "}]

After merging them, I would like to sort the combined array based on the price index.

If you have any tips on how to achieve this, please let me know. Thank you :)

javascript json

Answer 1

Answer №1

To convert JSON strings Object1, Object2, and Object3 into JavaScript objects, utilize the eval function.

After converting them, merge the objects using the concat method. http://www.w3schools.com/jsref/jsref_concat_array.asp

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

Next, sort the merged array using the sort method in JavaScript Array. References: http://www.w3schools.com/jsref/jsref_sort.asp https://developer.mozilla.org/en/JavaScript/Reference/Global_Objects/Array/sort

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

    // Explanation of the sorting process within this function...

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

});

For descending order, use return priceB - priceA;. jsfiddle: http://jsfiddle.net/diode/FzzHz/

.

Answer 2

To convert JSON strings Object1, Object2, and Object3 into JavaScript objects, utilize the eval function.

After converting them, merge the objects using the concat method. http://www.w3schools.com/jsref/jsref_concat_array.asp

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

Next, sort the merged array using the sort method in JavaScript Array. References: http://www.w3schools.com/jsref/jsref_sort.asp https://developer.mozilla.org/en/JavaScript/Reference/Global_Objects/Array/sort

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

    // Explanation of the sorting process within this function...

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

});

For descending order, use return priceB - priceA;. jsfiddle: http://jsfiddle.net/diode/FzzHz/

.

Answer 3

Answer №2

Transform them into objects and try using this method

Answer 4

Transform them into objects and try using this method

Answer 5

Answer №3

To combine the arrays, you can utilize the concat method:

var mergedArray = array1.concat(array2, array3);

Following that, you can proceed to sort the newly merged array.

Here is a custom sorting function that sorts based on the prod property (you can choose any property for sorting):

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

Finally, apply the sorting:

mergedArray.sort(sortByProd);

Answer 6

To combine the arrays, you can utilize the concat method:

var mergedArray = array1.concat(array2, array3);

Following that, you can proceed to sort the newly merged array.

Here is a custom sorting function that sorts based on the prod property (you can choose any property for sorting):

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

Finally, apply the sorting:

mergedArray.sort(sortByProd);

Combining and organizing two JSON objects

Answer №1

Answer №2

Answer №3

Similar questions

Sending a form from an iPhone device to a PHP backend server

Incorporating a JSON file through a script element

Is it possible to implement pagination using 'useSWR' in combination with the contentful-client?

The execution of Node.js callback function is not triggered

Is there a way to automatically adjust the size of a 'Pan' popup to fit the View in the ArcGIS JavaScript API?

How to pass arguments to the `find` method in MongoDB collections

Why is it that the function `val()` cannot be used with `$("#id")`?

Passing variable values from .post response to PHP: A guide

Is there a way for me to display the image name at the bottom before uploading it, and have a new div created every time I upload an image?

If the children prop is used to pass a server component to a client component, will it be displayed/rendered on the client side?

What's the most effective method for handling routes and receiving parameters in ExpressJS?

Link a distinctive number to a specific element

Definition of JSON Schema attribute: Field schema not supported for field... : Type of field is undefined

Updating a Tag's Class with the use of getElementsByTagName

Utilize MongoDB to store information within a sharding cluster and track the duration of data operations

Creating a Halo (external outline) for a circular sector in THREE.JS

The content in the div tag isn't showing up properly because of Ajax

Res.redirect is failing to redirect and displaying error message 'Connection Unavailable'

Utilizing JSON for Mapping Nested Grails Domain Classes

Saving the id in a variable after triggering an AJAX request by clicking