Free Trial

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 #443: Mystery of the Unjoined Records

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Spoiler
スクリーンショット 2024-09-24 100524.png
wbasuki
8 - Asteroid

My solution

Spoiler
Screenshot 2024-09-24 090209.png
Elango
5 - Atom

Great challenge

Flo_P
9 - Comet

Learned about these characters and how to identify via Regex, interesting!

Spoiler
image.png
Yogesh1795
8 - Asteroid

Change data type to V_ String to figure out the extra characters, used right and left function to eliminate those and join the tables.
Super Easy challenge

CSmith16
9 - Comet

Turns out that pesky secret character doesn't actually matter.

 

Here's my answer:

 

Spoiler
Screenshot 2024-09-24 080436.png
Screenshot 2024-09-24 080454.pngScreenshot 2024-09-24 080508.png

 

aatalai
14 - Magnetar

C443

Amy_smart
11 - Bolide

Here is my solution.

dmpope
8 - Asteroid
Spoiler
Screenshot 2024-09-24 105027.png
JAKupchik
7 - Meteor

Attached is my solution (spoiler!).  ~Thanks!  John