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 #22: Identify Values to Aggregate

jennifer_owens
8 - Asteroid

Did it two ways with columns and rows of data but I am sure there is a way to just use regex to do it. 

Naomi_I
8 - Asteroid
Spoiler
First time using the Tokenize method of the Regex Tool. Always love a challenge that makes me try something new!
Krzysztof_Hyla_1986
7 - Meteor

With every challenge I become better and better with the RegEx tool :-)

 

Spoiler
challenge_22_solution_KH.jpg

gawa
15 - Aurora

Done!

Spoiler
image.png
gawa
15 - Aurora

Post with solution file

josedlr00
8 - Asteroid

Good Challenge

SJKIM
8 - Asteroid

Done...


caltang
17 - Castor

Done!

 

Spoiler
image.png
DanielG
12 - Quasar

Solved

 

Pretty straight forward regex_replace formulas and text to columns approach.  I was maxed out on Regex working on Challenge 20 recently so I tried to minimize my use of it here.  😂

 

 

 

 

 

 

danielhoge
8 - Asteroid
Spoiler
Screenshot 2023-09-18 115028.png