Problem with regex search.

samsamtest

On my table I have example:
1 200,4
400
1 399

When I want to search fro. 1 399
In the search column I have to spell it exactly as the value. 1 399.
But I want to be able to search on 1399 and get the value.

I have turnes smart fals etc..
How can I solve this so I can search on 1399 and not 1 399.
Thanks
Kinde Regards
S

samsamtest

A example that datables have
https://datatables.net/examples/api/multi_filter.html
when. searching fore 162700 the I don't get any thing up.

Thanks
Kinde Regards
S

kthorngren

My suggestion is to use orthogonal data and remove spaces, etc from the numbers for the filter operation. You may also want to do this for the sort operation. Something similar to the 2nd Computed Values example.

Kevin

samsamtest

Thanks