Dear all,
I have a list of mobile phone numbers, which contains of 10 numbers some phone numbers have not been written correctly so, some phone numbers are contains more or less 10 digit number, I want to add a filter so that I will give my the numbers which are correct (have 10 digits number) the number which are less or more than 10 digit I want to get rid of them. How is it possible to do that in alteryx?
Hi @Feras95p ,
You can first convert the phone numbers into a string data type and then use a length function to return the number of characters withing each string
If the number is 10, that will come out of the T output anchor of the filter.
Let me know if that worked for you.
Cheers,
Angelos
Hi @Feras95p ,
You can also use the "ToString()" function in your statemen if you don't which to change the format type using a select tool.
Along with the solutions @Feras95p and @AngelosPachis have posted - you can use a data-cleanse tool to get rid of brackets, dashes and spaces, leaving only digits - and then use the length function in a function tool to check the remaining digits.