Ben SmithBen Smith
Ben Smith/
Combine Relation Properties
Combine Relation Properties
Combine Relation Properties

Combine Relation Properties

For
Hatty_DeWitt
From
Reddit
Status
Updating
Formulas
+
+
empty
empty
if
if
>=
>=
length
length
replace
replace
replaceAll
replaceAll
Share
Games
Players
Characters

First

if(empty(prop("Players")), "", replace(prop("Players"), ",.*$", "") + ": " + replace(prop("Characters"), ",.*$", ""))

Second

if(length(replaceAll(prop("Players"), "[^,]", "")) + 1 >= 3, replace(replace(prop("Players"), "^(.+?),", ""), ",.*$", "") + ": " + replace(replace(prop("Characters"), "^(.+?),", ""), ",.*$", ""), "")

Last

if(length(replaceAll(prop("Players"), "[^,]", "")) + 1 >= 2, replace(prop("Players"), ".*,", "") + ": " + replace(prop("Characters"), ".*,", ""), "")

Combined

if(empty(prop("Players")), "", replace(prop("Players"), ",.*$", "") + ": " + replace(prop("Characters"), ",.*$", "")) + if(length(replaceAll(prop("Players"), "[^,]", "")) + 1 >= 3, " -- " + replace(replace(prop("Players"), "^(.+?),", ""), ",.*$", "") + ": " + replace(replace(prop("Characters"), "^(.+?),", ""), ",.*$", ""), "") + if(length(replaceAll(prop("Players"), "[^,]", "")) + 1 >= 2, " -- " + replace(prop("Players"), ".*,", "") + ": " + replace(prop("Characters"), ".*,", ""), "")
 
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 Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!