Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #35: Data Cleansing Practice

Phil_dlM
7 - Meteor
Spoiler
 
TonyaS
Alteryx
Alteryx
Spoiler
clipboard_image_0.png
Tonya Smith
Sr. Technical Product Manager, cloud App Builder
Roman_Kornelly
7 - Meteor

Adding my solution. 

MachielVDK
5 - Atom

Here is my solution.
I tried to use regex to do most of the cleansing

anishanayak
7 - Meteor

Solution attached

nivi_s
8 - Asteroid

Challenge #35 solved!

 

Spoiler
Tried to do all of them with regex, but had to use formula for the last one!

clipboard_image_0.png
alexm06
8 - Asteroid

My solution

AlexC2
8 - Asteroid

My Solution:

MattBenj
9 - Comet
 
AndrewS
11 - Bolide

#35 regex inside formulas