Challenge #128: Settle the Score

[HardikJani]

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]

My solution:

[NMangera]

Spoiler

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]

REGEX, Dynamic rename, transform

[Shifty]

Fiddly but satisfying in the end. 😜

Spoiler

[vijaydholam]

Regex to quickly finish this one....😊

[Powerhouse_21]

Spoiler

[Yogesh1795]

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]

RegEx and Tokenize is useful!

[scooby_snacks]

My solution.