www.webdeveloper.com
Results 1 to 3 of 3

Thread: [RESOLVED] adding custom table sorting procedure

  1. #1
    Join Date
    Apr 2012
    Posts
    19

    resolved [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(" ");
    
        alert("a_array = " + a_array);
        alert("b_array = " + b_array);
    
        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. #2
    Join Date
    Feb 2006
    Posts
    2,927
    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 04:58 PM. Reason: it

  3. #3
    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;
      }

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles