DataTables and Regex search

jmeile

Dear all

I'm looking at the example:
https://datatables.net/extensions/fixedheader/examples/options/columnFiltering

I know how to look columns containing the search terms "Tokyo" or "London". I just have to input: "Tokyo|London" in the "Global search" field, then check: "Treat as regex". How can you look for rows containing: "Software" and "London"?

This should return this two rows:

Bradley Greer       Software Engineer   London  41  2012/10/13  $132,000
Bruno Nash          Software Engineer   London  38  2011/05/03  $163,500

Is this possible? What do I have to type in the "Global search" field?

Best regards
Josef

jmeile

I think I found it:

(?=.*\bsoftware\b)(?=.*\blondon\b)

This seems to work. Is that the correct way?

My idea is offering the user a search input to enter keywords separated by semicolons.Right after, he will have two radio buttons: "Match any" and "Match all".

In order to avoid real time processing, I will catch the "keydown" handler and wait until the user hits the ENTER key. Then I will split that string into an array of search terms and then join them with the or operator '|' or by using the previous regex.

Now, I'm facing another problem. If I want to match a phrase, for example: "Software Engineer" and "London", this regex won't work:

(?=.*\bsoftware engineer\b)(?=.*\blondon\b)

How should be this formatted?

jmeile

Sorry, it is actually working. I think I make a typo. By the way, I just noticed that the \b modifier only matches if it is next to a word delimiter, for example: an space or a tab. But I want to match everything, so, I replaced it by:

(?=.*oftware enginee.*)(?=.*ondo.*)

So that, It will match the rows I want.

jmeile

Just for the records: the example I linked before is the wrong one. I was using this one:
https://datatables.net/examples/api/regex

which actually has regex support.