Hello everyone!
I have phone numbers in contacts written in different forms, with whitespaces, without, in group of 2 - 3 digits.
How to search in those all forms entering number in search form as one continous string of digits?
Let's say writing in search form - 123456789 i want to get results with phone numbers:
123456789
123 456 789
12 34 56 789
+33 12 34 56 789
etc.
The solution (stupid?) is to add wildcard "%" between each letter in search form - %1%2%3%4%5%6%7%8%9%
But maybe there is another - better solution? :)
Hello Lucas,
Would you prefer to keep the spaces in the numbers? As I have a solution which will remove all spaces, meaning that you wouldn't need the wildcard.
Thanks,