replaceAll(replaceAll(prop("Played By"), "(\\b\\S+\\b)(?=.*\\1)", ""), ",", "\\n")
replaceAll(replaceAll(prop("Games Played"), "(\\b\\S+\\b)(?=.*\\1)", ""), ",", "\\n")
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.
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>