Javascript Sort on 2D array

Question

I want to sort the data1 by second column. I tried the below code but it seems sorting is not right. If I try with a single dimension array, the results are correct. What am I doing wrong?

function test(){
  var data1 = [['MED1000','ZITHROMAX 15ML'],
              ['MED01188','AZILEB TABLET 500MG'],
              ['MED1212','AGOMET-200MG (METRONIDAZOLE) TABLET']
             ];
  
data1.sort(function(a, b) {
    return a[1] - b[1];
});
Logger.log(data1); // this does not produce right results 
// output:  [[MED1000, ZITHROMAX 15ML], [MED01188, AZILEB TABLET 500MG], [MED1212, AGOMET-200MG (METRONIDAZOLE) TABLET]]
var data2 = ['ZITHROMAX 15ML','AZILEB TABLET 500MG','AGOMET-200MG (METRONIDAZOLE) TABLET'];
data2.sort();
Logger.log(data2); // this works
// output : [AGOMET-200MG (METRONIDAZOLE) TABLET, AZILEB TABLET 500MG, ZITHROMAX 15ML]
}

cmgchess · Accepted Answer · 2021-10-28 05:55:51Z

2

referenced Array.prototype.sort()

data1.sort(function(a, b) {
    return a[1] - b[1];  //This would work if the values are numbers not strings.
});

you need to use <,> operators for strings

 var data1 = [['MED1000','ZITHROMAX 15ML'],
              ['MED01188','AZILEB TABLET 500MG'],
              ['MED1212','AGOMET-200MG (METRONIDAZOLE) TABLET']
             ];
   
data1.sort((a,b) => (a[1] > b[1]) ? 1 : ((b[1] > a[1]) ? -1 : 0))

console.log(data1)

for numbers your method would work

 var data1 = [['MED1000','ZITHROMAX 15ML',6],
              ['MED01188','AZILEB TABLET 500MG',7],
              ['MED1212','AGOMET-200MG (METRONIDAZOLE) TABLET',3]
             ];
   
  data1.sort(function(a, b) {
    return a[2] - b[2];
  }); 

console.log(data1)

answered Oct 28, 2021 at 5:55

cmgchess

10.3k42 gold badges55 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

Javascript Sort on 2D array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related