I want to evaluate phone numbers. Unfortunately, there are many characters that do not belong in the phone number.
I would like to sort out or mark all unusable phone numbers in the loading script.
This includes all letters (A-Z) and special characters, etc.
Which function can I use to do this best?
if(WildMatch(CalledNumber, '*#*', '*ABCDEFGHIJKLMNOPQRSTUVWXYZ#abcdefghijklmnopqrstuvwxyz.:-ß@/%^\*')>0, 'NO', 'YES') as Flag_Useable
It doesn't work with "WildMatch"function.
Can you help me please? 😀