Retrieve unique data from table column and sorting array

Question

There is one table , and I want the unique values of table column data, like table row may have 4, 2 , 2, 4,5 , 4. So it should return array like this data = [ 2 , 4 , 5 ]

I am able to achieve this using jquery as below link

http://jsbin.com/ojeroc/5/edit#source

But data should come in ascending order So I can use this array in another function.

$(document).ready(function(){
    console.log("document is ready");          
    var items=[], options=[];
    console.log(items);
    console.log(options);
    //Iterate all td's in second column
    $('#dataTable tr  td').each( function(){
    //console.log("Inside tr data");                                                                                                         
       //add item to array
       items.push( $(this).text() );       
      // console.log($(this).text());
    });
    //restrict array to unique items
    var items = $.unique( items );
    alert(items);
});

mas-designs · Accepted Answer · 2012-03-05 09:40:43Z

2

function sortNumber(a,b)
{
      return a - b;
}

var n = ["10", "5", "40", "25", "100", "1"];
document.write(n.sort(sortNumber));

would create this output:

1,5,10,25,40,100

You could also wrap it in an anonymous function

n.sort(function(a,b){return a-b;})

Which would be faster, but if you need to use it over and over again, I would stick with the function.

edited Mar 5, 2012 at 9:40

answered Mar 5, 2012 at 9:33

mas-designs

7,5311 gold badge33 silver badges56 bronze badges

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

1 Comment

mas-designs Over a year ago

Hope it was helpful for you ;-)

Didier Ghys · Accepted Answer · 2012-03-05 09:38:27Z

1

You can use Array.sort() method to sort array items:

var sortedItems = $.unique( items ).sort(function(a, b) {
    return a - b;
});

The function passed as parameter is used to compare two items in the array. It receives two elements.

The sorting is done by returning a negative/positive/zero number. To compare numbers, you can then simply substract b from a.

DEMO

answered Mar 5, 2012 at 9:38

Didier Ghys

30.6k9 gold badges77 silver badges82 bronze badges

3 Comments

Wazdesign Over a year ago

Thanks, I want to retrieve minimum and maximum values of the sorted array , can that be done?

kapa Over a year ago

@Wazdesign If you think for a second, you will see it is easy.

Didier Ghys Over a year ago

After the sort, sortedItems[0] will get you the min and sortedItems[sortedItems.length-1] the max.

Collectives™ on Stack Overflow

Retrieve unique data from table column and sorting array

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related