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 #153: And the Oscar goes to...

rcarog
8 - Asteroid

Solution attached.

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1614982603701.pngToons_1-1614982621123.png

 

 

mot
11 - Bolide

Solution attached.

AndrewS
11 - Bolide

#153

Spoiler
153.PNG153_2.PNG
JoshML
Alteryx
Alteryx
Spoiler
Challenge 153 Solution.png
mpennington
11 - Bolide

Enjoyed this one.  

 

 

Spoiler
The single category separated by a comma in a Star is Born was tricky, the rest were semicolons. 
I was probably too proud of this formula for extracting the nominee:

IIF([Dash?], REGEX_Replace([Details], '(.*)\s-\s(?:Screenplay|Written)*(?:\sby\s)*(.*)', '$2'),Null())​

MP 153.jpg

 

 

WernerE
8 - Asteroid
Spoiler
Screenshot_1.png
joelmiller66
9 - Comet
Spoiler
Challenge 153 Image 2.pngChallenge 153 Image.png
MichelleL
Alteryx
Alteryx

Fun!

mnmemilymnm
8 - Asteroid

Solution attached. For the drop-down tool, rather than pulling the Award Category names from the Oscar Winners text file, I wanted to give myself some extra RegEx practice, so I pulled the Award Category names from the Oscars Log text file.