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 #2: Preparing Delimited Data

lanidinh
7 - Meteor

Done

CurtisPaterson
8 - Asteroid

Challenge 2.png

Erinashlee2
6 - Meteoroid
Completed
 

Challenge2Completed.PNG

 

pavan2023
5 - Atom

My Soln

Spoiler
image.png
avbade
6 - Meteoroid

My Solution

pmag
8 - Asteroid
Spoiler
image.png

 

dinazulaikha18
8 - Asteroid

My answer >.<

roopmathi
7 - Meteor
Spoiler
Here is my approach 
> Used formula tool to clean up and parse upstream
1. I removed " and ' using REPLACE () in the formula tool
2. I converted the date string from 16-JUN-01 to YYYY-MM-DD using replace and regexp_replace
I used Chat-GPT to help me with the syntax for both. I wouldn't know how to write this myself without looking at the documentation
> Then used the Text to Columns tool to split by delimiter,
formulas used.png

 

Challenge#2 soln by RG.png

 




JasperMB
8 - Asteroid
Spoiler
Challenge #2_JB.png

ArunjotSingh
5 - Atom

My solution to challenge 2