Jquery to validate if input exists in particular table column

Question

I have a table containing a list of unique values in the second column. There is an input field to add a new row onto the field, but before inserting the row, I want to validate that the particular field value does not already exists in the table.

In my on-click event, I have tried the following:

if ($('#tablename tr > td:contains('+VALUE+')').length!=0)
{
    alert("Please enter a unique row number.");
}

The problem with this is that it does not limit to a certain column, so if I enter a value that exists in any other cell of the table, it displays the alert. How can I restrict it to searching for an exact match, and only in the second column.

THanks!

Arun P Johny · Accepted Answer · 2013-11-15 15:42:56Z

2

Try

if ($('#tablename tr > td:nth-child(2):contains(' + VALUE + ')').length != 0) {
    alert("Please enter a unique row number.");
}

it may not be proper because of a row contains abc and then you try to add ad it won't allow, so try

var $tds = $('#tablename tr > td:nth-child(2)').filter(function () {
    return $.trim($(this).text()) == VALUE;
});
if ($tds.length != 0) {
    alert("Please enter a unique row number.");
}

edited Nov 15, 2013 at 15:42

answered Nov 15, 2013 at 15:30

Arun P Johny

389k68 gold badges532 silver badges532 bronze badges

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

2 Comments

Bill Criswell Over a year ago

I was just typing up your second demo. Heads up though, you forgot return in filter().

Nate23VT Over a year ago

Your second piece of code worked great. Thanks for the prompt reply!

Collectives™ on Stack Overflow

Jquery to validate if input exists in particular table column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related