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

archiemclean
6 - Meteoroid

Attached

archiemclean
6 - Meteoroid

Attached.

VipulThakur
7 - Meteor

Solved

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

My Solution 

chandler-gjino
Alteryx
Alteryx

Attaching my solution

graysonpierpoint
7 - Meteor

Solved

kaitlinDS37
8 - Asteroid
Spoiler
kaitlinDS37_0-1684402336770.png

 

katejoyce87
8 - Asteroid

:)

barbosaus
8 - Asteroid

here is my solution.

However, I would like to check some points in order to see if what I have done is acceptable or not. I didn't use the regex tool, however, I used the expression regex_replace to get the same result on exercise 2. is that ok?

Same for exercise 3.

about exercise 4, I tried different methods to write just one expression that could attend all the conditions, but I didn't get it, so in my formula tool, there are 3 formulas inside. Is that ok?

Do I need to follow any specific rules or criteria, or does it not matter how it is counted as long as I receive the same answer?


nbilal
7 - Meteor

Here's my solution. REGEX and conditionals make it easy to solve almost any problem, though I'm curious how performance scales with the complexity of the formulas...