It seemed like this took waaay too many tools. That usually means I am brute-forcing the solution and not looking for elegantnesses
Spoiler
I used the following method to get the unique letters in a word
I used the following method to get the unique letters in a word
REGEX_Replace([Field_1], "(.)(?=.*\1)", "")The group (.) matches any character, and the lookahead group (?=.*\1) checks for any other proceeding occurrences of that character. This means that the last occurrence of a letter is kept, so the results look a little different (but doesn't affect point calculation).
| Word | Letters | Points |
| disinterestednesses | irtdnes | 26 |
