Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

My solutions; One tool per case

Solution

See attached for solution! Good practice for those who are new to string data cleanse.

My solution:

My solutions

Its fun to play with data using Formula tool.

Here is my solution...a little different than your solution but it does the trick.

Different to other challenges in that there were multiple challenges in this one :)

Challenge #35: Data Cleansing Practice