Played By (Regex)
replaceAll(replaceAll(prop("Played By"), "(\b\S+\b)(?=.*\1)", ""), ",", "\n")
Games Played (Regex)
replaceAll(replaceAll(prop("Games Played"), "(\b\S+\b)(?=.*\1)", ""), ",", "\n")
Note on Regex Patterns
These regex patterns only work the first time they're saved as extra \
s are added that cause the formulas to fail the next time they're edited.
(\b\S+\b)(?=.*\1)
becomes (\b\\S+\b)(?=.*\\1)
→ removing the extra \
s before S
and 1
allows the formulas to work again.