Ben SmithBen Smith
Ben Smith/
Content in Parentheses
Content in Parentheses
Content in Parentheses

Content in Parentheses

For
Kirby
From
Slack
Status
Updating
Formulas
replace
replace
replaceAll
replaceAll
Share

First Set Only

if(test(prop("Name"), "[(]|[)]"), replace(replace(prop("Name"), "[^(]*[(]", ""), "[)](.*)", ""), "")

All Sets

replaceAll(replaceAll(replaceAll(prop("Name"), "[A-z0-9,. ](?![^(]*[)])", ""), "[)][(]", " "), "[(]|[)]", "")

All Sets (Comma-separated)

replaceAll(replaceAll(replaceAll(prop("Name"), "[A-z0-9,. ](?![^(]*[)])", ""), "[)][(]", ", "), "[(]|[)]", "")
 
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!