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

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1618950892436.png

 

Cheers!

Phil

CandiceDB
Alteryx
Alteryx

My solution:

 

Spoiler
CandiceDB_0-1619347047927.png

 

ENix
8 - Asteroid
Spoiler

ENix_0-1620660878875.png

 

j_trefethen
8 - Asteroid

Took me a while with Regex101 and the Community here to sort out the Regex needed. Once I got that part, the Regex split to rows option made the rest pretty easy.

bjkay30
8 - Asteroid

Nice challenge - I think I'm starting to get the hang of RegEx...

 

Spoiler
bjkay30_0-1622124685006.png

 

RashedDS
8 - Asteroid

My solution for week 22

 

Spoiler
Week22.JPG

 

TKSnider
8 - Asteroid

Once I figure out the format of the record, this was pretty straight forward.

 

My solution below

Erin
9 - Comet
Spoiler
Submission attached. This ties to the posted solution, but not sure why my summary tool works on dollars. 
Ajjay
8 - Asteroid

Soln

ARussell34
8 - Asteroid

Not too bad, still getting used to the Trim() function(s) !