SOLVED
Cleaning Data Set
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JingYih_Herbalife
8 - Asteroid
‎11-03-2021
02:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have this set of data with mobile numbers that are not organized.
I want to sort out the data, by removing all symbols, and separating all the mobile numbers into multiple columns as per below;
Appreciate some help on this.
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
2 REPLIES 2
AlexEntz
8 - Asteroid
‎11-03-2021
02:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎11-03-2021
02:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your prompt response. This helped 🙂
