I have a very generic situation on filter but unable to find a solution for it.

Sh_Si

I am trying to find a solution to filter a column which contains the amount value formatted with comma like 1,234,789. Search function does the exact string match. For e.g. when I search for 12 , it does not return anything but when I search for 1,2 it returns the rows. Basically it is doing a exact string match. Is there a way that when we search for 12 it returns both 123 and 1,234?

colin

Hi @Sh_Si ,

You would need to create a custom search filter for this. This one here is similar and could be used as a template - it's for phone numbers, but it matches multiple ways of searching.

Cheers,

Colin