I'm trying to sort a multidimensional array. what should i put on the callback of javascript .sort() function to make it behave like mysql order by?
Example. Using mysql order by, result:
acx,
acx abx,
acx acx,
S&P/ASX 20
Using sort function in js, result:
S&P/ASX 20,
acx,
acx abx,
acx acx
Thank you.
The problem is that sorting in JS is case-sensitive. To get around that, provide a function as an argument to sort, which should compare upper-cased (or lower-cased for that matter) versions of strings.
function cmp(x, y) {
return x > y ? 1 : x < y ? -1 : 0;
}
a = ["S&P/ASX 20","acx", "acx abx","acx acx"]
a.sort(function(x, y) {
return cmp(x.toUpperCase(), y.toUpperCase())
})
It's unclear what your multiple dimensions are, but your examples look like they're just sorted without case sensitivity.
In any case, to get custom behavior, what you do is pass a function into sort that compares elements, returning -1, 1, or 0. So for instance:
yourArray.sort(function(a, b) {
a = a.toLowerCase();
b = b.toLowerCase();
if (a < b) {
return -1;
}
if (a > b) {
return 1;
}
return 0;
});
If you're comparing an array of arrays, within the comparison function, you'd compare the various entries in the two arrays you were given in a and b.
[javascript] string sort case.