Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFirst time using RegEx. Not as scary as I thought!
I did kind of a backward way of getting to the answer, but got to it. I regex'd to tokenize each letter in the score. Then i summarized and counted each occurrence of uppercase and lowercase letter. From there I split up upper and lower case letters with a filter and then assigned numeric scores to each using the formula tool. I then cleansed the uppercase to lowercase letters so i could join the scores to add them. I then added each score for each letter by using the summarize tool and found that letter E won with a score of 8!