Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Weekly Challenge

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 #128: Settle the Score

HardikJani
7 - Meteor

Hi....thanks for the challenge. Of all the challenges I have solved till now this was the most interesting. My approach was very primitive but I love looking at other solutions and learning. I first split everything to rows to get in one field. Then split the lower case and upper case letters. And used the summarise tool to get counts and multiplied by -1 to get the negatives. After I got everything togather I used cross tab to get the pivot and used multi row formula to get the final scores. I had to use one tool for each round here which is think should not be this complicated. Looking forward to getting to understand better solutions.

alacoume
8 - Asteroid

My solution:

NMangera
10 - Fireball
Spoiler
NMangera_0-1680899977401.png

 

TA

1. RegEx: Tokenise and split to rows

2. Formula:  REGEX_Match with optional case sensitive turned on

3. Crosstab: total column when aggregating values

PrachiD
8 - Asteroid

REGEX, Dynamic rename, transform

Shifty
12 - Quasar

Fiddly but satisfying in the end. 😜

 

Spoiler
Shifty_0-1681290335623.png

 

vijaydholam
7 - Meteor

Regex to quickly finish this one....😊

Powerhouse_21
8 - Asteroid
Spoiler
Powerhouse_21_0-1681407671533.png

 

Yogesh1795
8 - Asteroid

This Challenge is a nightmare if someone don't know what tokenize is.


I tried regex to replace space b/w each character and couldn't succeed. Anyways, happy that I tried tokenize without any help.

 

I used regex as my formula was case sensitive

Goddenra
8 - Asteroid

RegEx and Tokenize is useful!

scooby_snacks
8 - Asteroid

My solution.