Finding patterns in Phone Attribute

[ernzdl]

I have a phone attribute and I want to find the patterns. For example, how many ########## or how many are (###)###_#### or how many are ######### or how many are # or # ### ### #### etc.

Can you help me with this?

[ernzdl]

Thank you, Akshay!

[Akshay1 · Accepted solution]

Step 1: Convert the Phone Number Column that you have into text using the change into text option using our column operation menu.


Step 2: Use a compute column to replace all the numbers in the phone number column with a # using the following compute Statement


Step 3: Then use a shape operation to do a group by on Phone Number Pattern and use count as an aggregate to get your desired output.


Note: You could use STR(REGEX(@Phone Numbers@,"[0-9]","#")) in the second step and ignore the first step as an alternative solution.