How do I sort a json by numeric value?

Question

How would I go about sorting a json into an array by numeric value and then how would I easily access that information.

{"362439239671087109":{"coins":19},"178538363954003968":{"coins":18},"234255082345070592":{"coins":137}}

The weird numbers are discord user ids.

That's not an array, it is a dictionary (also called hashmap) - these things can't be sorted. You can convert it into an array - would that help? — SQL Hacks, Jul 13 '18 at 22:02

score 0 · Answer 1 · answered Jul 13 '18 at 22:06

0

Ummm. First, make associative array, if the json is generated from bakcend, by example in php, you can use functions for order arrays. ---> http://php.net/manual/en/array.sorting.php See this: Converting JavaScript object with numeric keys into array

answered Jul 13 '18 at 22:06

bashman

138
2
11

Your first link is for PHP, not Javascript. JS doesn't have associative arrays. – Barmar Jul 13 '18 at 22:32

score 0 · Answer 2 · answered Jul 13 '18 at 22:07

0

var a = {"362439239671087109":{"coins":19},"178538363954003968":{"coins":18},"234255082345070592":{"coins":137}};
var b = Object.keys(a);
b.sort(function(x,y){return a[x].coins-a[y].coins});
console.log(b);

answered Jul 13 '18 at 22:07

SQL Hacks

1,322
1
10
15

Thanks for awnsering so quickly, the json is added to and changed very often, could I instead just call the json file in (var a =) – Nathan Hodgson Jul 13 '18 at 22:09
Sorry, I don't understand. Perhaps you can edit your question to explan. – SQL Hacks Jul 13 '18 at 22:12
How would I go about reversing this. This currently sorts them from least to most – Nathan Hodgson Jul 14 '18 at 00:42
If these numbers are going to keep getting big, watch out for exceeding `Number.MAX_SAFE_INTEGER`. `9007199254740991` – Jeremy J Starcher Jul 14 '18 at 05:51
**@Nathan**, If someone's answer solved your problem then you should up vote/accept it. – hygull Jul 14 '18 at 06:08

score 0 · Answer 3 · answered Jul 14 '18 at 05:58

// Code that can handle VERY large numbers by treating them as strings.


var a = {
  "362439239671087109": {
    "coins": 19
  },
  "178538363954003968": {
    "coins": 18
  },
  "234255082345070592": {
    "coins": 137
  }
};


function padWithZeros(s) {
  return ("000000000000000000000" + s).substr(-20);
}

var b = Object.keys(a);
b.sort(
  function(x, y) {
    var s1 = padWithZeros(a[x].coins);
    var s2 = padWithZeros(a[y].coins);

    if (s1 === s2) {
      return 0;
    }

    if (s1 > s2) {
      return 1;
    } else {
      return -1;
    }


  });
console.log(b);

How do I sort a json by numeric value?

3 Answers3