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

Jeremy
8 - Asteroid

My solution attached.  Removing leading zeros seems pretty straightforward if you just convert it to a number.  Is there something else we're supposed to do with leading zeros?

FlaviaGauna
5 - Atom

   

axelsteenberg
7 - Meteor

My solution for the challenge.

abhijeet_ghosh
5 - Atom

Here is my submission:

1. Here I have replaced the Zero using this formula: Replace([Field1], "0", "")

abhijeet_ghosh_0-1652127947374.png

2. Here I have first used regex (\<0*) and then used Text to Column to split the number and the text.

abhijeet_ghosh_1-1652128033701.png

3. Here I have used regex (ID$) to remove the word ID from the end

abhijeet_ghosh_2-1652128189328.png

4. Here I have used formula to accomplish the result.

Formula:
IF Length([Safety Code])<8 THEN "SC" + [Safety Code] ELSE Left([Safety Code], 8) ENDIF

abhijeet_ghosh_3-1652128302548.png

 

 

Powerhouse_21
9 - Comet
Spoiler
Powerhouse_21_0-1652133453200.png

 

jhaines
7 - Meteor

Good review of data prep tools. Tried to use as few tools as possible.

Spoiler
jhaines_0-1652289038327.png

 

SkomantasTamulaitis
8 - Asteroid

Solved!

Spoiler
Screenshot 2022-05-12 132144.png
roycephillipsjr
7 - Meteor

here is mine

Liam_Bremner
7 - Meteor

my solution

m-wolters
8 - Asteroid

My solution