Game Nights

Game Nights

For
From
Facebook
Status
Updating
Formulas
Share
Game Nights
Board Games
Participants

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.
 
By Ben  •  Latest  •  Was this helpful? Please consider buying me a coffee. Cheers!By Ben  •  Latest  •  Was this helpful? Please consider buying me a coffee. Cheers!
By BenLatest • Was this helpful? Please consider buying me a coffee. Cheers!