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

Lakshmi96
6 - Meteoroid

solution

mohitch
7 - Meteor

Solution

dpatnaik97
7 - Meteor

Done and attached.

CKP
10 - Fireball

My solution

 

Spoiler
challenge_35_mysolution.jpg
Skrupczak
7 - Meteor

I used some formula tools, and some regex, since I can always use practice with that! 

pagrawal
7 - Meteor
Spoiler
spoiler
aman_goyal
8 - Asteroid

Please check my solution -

aman_goyal
8 - Asteroid

Easy Challenge - Easy Solution

chinedu
7 - Meteor

I have a challenge with the last exercise

I ran the following in the formula tool:

IF Length([Safety Code])>8
THEN Left([Safety Code], 😎
elseif Length([Safety Code])=6
then PadLeft([Safety Code], 2, "SC")
ELSE [Safety Code]
ENDIF

 

but cant get the desired result. It did not Padleft "SC'" to record output 1.

 

Can someone please help me with this?

 

Thanks

DataSciencePro
7 - Meteor

Done!