Report Filters

Content

Is there a way to remove spaces from the data being searched?

For example, if the phone number data contains phone numbers such as:

0123456789

0123 456 789

If I search for 0123456789, it won't find 0123 456 789

So effectively I want to be able to do something like this in the filter expression:

    str_replace(" ", "", contacts.any_phone)

Can I add new string functions to the filter's available functions?

Version

February 2017