Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Cleaning Data Set

JingYih_Herbalife
7 - Meteor

I have this set of data with mobile numbers that are not organized.

JingYih_Herbalife_3-1635930196691.png

 

 

I want to sort out the data, by removing all symbols, and separating all the mobile numbers into multiple columns as per below;

JingYih_Herbalife_5-1635930279580.png

 

Appreciate some help on this.

2 REPLIES 2
AlexEntz
8 - Asteroid

Hello JinYih,

 

you can seperate the telephone numbers by using the text to column function. The Delimeter is "/" in your case.

 

To remove the parenthesis you have to use the formula tool and then the expression: trim(Mobile Number, "(") then use another expression: trim(Mobile Number, ")").

 

Hope this helps. Please provide an excel sheet with data if you wish for me to create an example workflow.

 

Greetings Alex

JingYih_Herbalife
7 - Meteor

Thank you for your prompt response. This helped 🙂 

Labels