Weekly Challenge

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

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

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #35: Data Cleansing Practice

Highlighted
6 - Meteoroid

solution

Highlighted
7 - Meteor

Solution

Highlighted
7 - Meteor

Done and attached.

Highlighted
10 - Fireball

My solution

 

Spoiler
challenge_35_mysolution.jpg
Highlighted
7 - Meteor

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

Highlighted
6 - Meteoroid
Spoiler
spoiler
Highlighted
7 - Meteor

Please check my solution -

Highlighted
7 - Meteor

Easy Challenge - Easy Solution

Highlighted
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

Highlighted
7 - Meteor

Done!