1. Registered User
Join Date
Apr 2012
Posts
19

## [RESOLVED] adding custom table sorting procedure

I have a javascript file that is used to sort my html table. All of the standard data types are being sorted correctly. For example, I have columns of numbers, alphanumeric characters, and dates that are all being sorted correctly.

One of my columns displays data that needs to be sorted a different way. Example cells look like:

3 X 4
2 X 5
1 X 3

Does the above data fit this regular expression? /[0-9]\s[A-Z]\s[0-9]/
Or, is there a better one that I should use to match the data type?

After I match the data type, I move to the sorting function. What I want to do is compare to cells, and swap them if necessary based on a condition. So, if I have the following two cells (a) and (b):

a = 3 X 4
b = 4 X 3

first what I do is multiply the first number by the second. So, the product of a is 12 and the product of b is 12. Usually, I would want to sort by product, but when the product is the same I want to sort by whichever cell has the greatest second number (a in this case).

Here is my sorting function:

Code:
```sort_lxc: function(a,b) {
var a_array = str.split(" ");
var b_array = str.split(" ");

var lxc_product1 = a_array[0] * a_array[2];
var lxc_product2 = b_array[0] * b_array[2];

if (lxc_product1 == lxc_product2) {
if (a_array[2] > b_array[2]) {
return -1;
}
if (a_array[2] < b_array[2]) {
return 1;
}
if (a_array[2] == b_array[2]) {
return 0;
}
}
if (lxc_product1 < lxc_product2) return -1;
return 1;
}```
The above function doesn't seem to work and I can't figure out why. I am fairly new to javascript so any help is appreciated. Thanks!

2. Registered User+
Join Date
Feb 2006
Posts
2,930
Where does str come from in your code, and why are you splitting it on a space instead of 'x' or ' x '?
Last edited by mrhoo; 04-30-2013 at 03:58 PM. Reason: it

3. Registered User
Join Date
Apr 2012
Posts
19
Woops! str is supposed to be a and b respectively, and I guess it would be better to split on " X " instead of just the space.

Per your inquiries, I changed my code to this and it worked! Thanks for spotting that!

Code:
```sort_lxc: function(a,b) {
var a_array = a.split(" X ");
var b_array = b.split(" X ");

var lxc_product1 = a_array[0] * a_array[2];
var lxc_product2 = b_array[0] * b_array[2];

if (lxc_product1 == lxc_product2) {
if (a_array[2] > b_array[2]) {
return -1;
}
if (a_array[2] < b_array[2]) {
return 1;
}
if (a_array[2] == b_array[2]) {
return 0;
}
}
if (lxc_product1 < lxc_product2) return -1;
return 1;
}```