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
7 - Meteor

  

Highlighted
7 - Meteor
Spoiler




More than 8 and 6 length casesMore than 8 and 6 length casesRemove ID at the endRemove ID at the endRemove Leading 0 and descriptive textRemove Leading 0 and descriptive textRemoved Leading ZeroesRemoved Leading Zeroes

Very Interesting Problem, How Can I Do It Better ?

Highlighted
6 - Meteoroid

Hi,

Here you go

Highlighted
Alteryx
Alteryx

My solution:

Highlighted
8 - Asteroid

 

 

Spoiler

Solution Attached

balajilolla_0-1590078882091.png

 

Highlighted
8 - Asteroid

RegEx is your friend, I recommend my fellow Alteryxers to check this out:

 

https://regexr.com/55545

 

You can use GitHub to sign in

 

Spoiler
izamryan_0-1590156506521.png


My regexs to solve were:

.*(\d{4}).*

(0*)(\d*)
and strip out the 1st token, just take the 2nd token

(ID)$
strip out the string "ID" from every line

\w{8}
this needs to be paired with a formula before:
IF Length([Safety Code])<8 THEN "SC"+[Safety Code] ELSE [Safety Code] ENDIF

Highlighted
11 - Bolide
Spoiler
 
Highlighted
6 - Meteoroid

Solution to challenge 35.

Highlighted
6 - Meteoroid

my solution

Highlighted
7 - Meteor

Be well!