Find duplicate values on selected rows in table jquery

Question

I have a table in my HTML,

<table>
        <tr><td>1</td><td>2</td><td>3</td></tr>
        <tr><td>a</td><td>2</td><td>c</td></tr>
        <tr><td>x</td><td>2</td><td>3</td></tr>
        <tr><td>1</td><td>2</td><td>3</td></tr>
    </table>

And i wanted to find duplicate contents in the first and the second <td> elements contents.

This is what i got so far:

$(function() {
        $("table tr").each(function() {

        });
    });

I m stuck on selecting the first and the second element and comparing them. Do i just add a class or use jquery selector?

What do you want to do when you find dupes? And I'm assuming that you mean duplicate values in the same column between rows. — j08691
– j08691, Commented Oct 31, 2015 at 19:14
So in your example, the last row, first column should be cleared, and every second column except the first (containing a 2) should be cleared? — j08691
– j08691, Commented Oct 31, 2015 at 19:22
So basically in my example the first and the last row would be cleared -they both have the same <td> element in the first and the second column.(These are the only columns i wanted to compare for same values) — shell
– shell, Commented Oct 31, 2015 at 19:31

user1399844 · Accepted Answer · 2015-10-31 19:38:18Z

3

This is how you find the duplicates in a column, if I understood.

You can use instead of .addClass, .remove() if you want to remove it.

http://jsbin.com/wenuwewide/edit?js,console,output

  $('tr').each(function() {

      $(this).find('td').each(function(i) {

        if(values[i].indexOf($(this).text()) > -1) {
          $(this).addClass('duplicate');
        }

        values[i].push($(this).text());          
      });

    });

answered Oct 31, 2015 at 19:38

user1399844

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

Comments

Gonzalo.- · Accepted Answer · 2015-10-31 19:40:30Z

2

just store the combination of the first two values as properties in an object

$(function() {
   var el = {};
   $("table tr").each(function() {
        // get row
        var row = $(this);
        // get first and second td
        var first = row.find('td:first-child').val();
        var second = row.find('td:nth-child(2)').val();
        // if exists, remove the tr
        if(el[first + second]) {
            $(this).remove())
        }
        else {
            // if it does not exist, add it with some random val
            el[first + second] = 1;
        }
   });
});

answered Oct 31, 2015 at 19:40

Gonzalo.-

12.7k5 gold badges53 silver badges84 bronze badges

Collectives™ on Stack Overflow

Find duplicate values on selected rows in table jquery

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related