I have a very generic situation on filter but unable to find a solution for it.
I have a very generic situation on filter but unable to find a solution for it.
Sh_Si
Posts: 1Questions: 1Answers: 0
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?
This discussion has been closed.
Answers
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