JQuery DataTable plugin, how do I search an exact string ?
I have the jQuery datatable plugin, ( https://datatables.net/reference/api/search() )
And I want to find an exact substring in the table search function.
For example, if the value is, Apr, then it should not bring back, type":"CAPR","Hours, because CAPR contains, APR.
Here is how the code looks currently,
And here is an example of something I’ve tried:
But the search automatically splices off the empty spaces and brings back strings with, CAPR, again.
And I want to find an exact substring in the table search function.
For example, if the value is, Apr, then it should not bring back, type":"CAPR","Hours, because CAPR contains, APR.
Here is how the code looks currently,
$("#MonthFilter").change(function () {
var dataTableObj = $('#SupervisorList').DataTable();
var val = $("#MonthFilter").val();
dataTableObj.column(16).search(val).draw();
});
And here is an example of something I’ve tried:
$("#MonthFilter").change(function () {
var dataTableObj = $('#SupervisorList').DataTable();
var val = $("#MonthFilter").val();
val = " "+val+" ";
var col16 = dataTableObj.column(16).search(val).draw();
});
But the search automatically splices off the empty spaces and brings back strings with, CAPR, again.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I had to make some very minor adjustments to make it work. The two below worked for me, but they are based on David's use of the \s as a regex space.
$("#MonthFilter").change(function () {
var dataTableObj = $('#SupervisorList').DataTable();
var val = $("#MonthFilter").val();
val = "\\s" + val + "\\s";
var col16 = dataTableObj.column(16).search(val,true,false).draw();
});
$("#MonthFilter").change(function () {
var dataTableObj = $('#SupervisorList').DataTable();
var val = $.fn.dataTable.util.escapeRegex( $("#MonthFilter").val() );
val = "\\s" + val + "\\s";
var col16 = dataTableObj.column(16).search(val,true,false).draw();
});
JavaScript
JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and in almost every mainstream web browser.
127K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
Open in new window
But it also brought back CAPR.