Ben SmithBen Smith
Ben Smith/
Split Text at Character
Split Text at Character
Split Text at Character

Split Text at Character

For
Red Gregory
From
Status
Updating
Formulas
+
+
contains
contains
if
if
replace
replace
Share
Entries

Before :

contains(prop("Name"), ":") ? replace(prop("Name"), ":(.*)", "") : ""

After :

contains(prop("Name"), ": ") ? replace(prop("Name"), "^[^:]*: ", "") : ""

First Bit

contains(prop("Name"), prop("Split at")) ? replace(prop("Name"), prop("Split at") + "(.*)", "") : ""

Second Bit

contains(prop("Name"), prop("Split at")) ? replace(prop("Name"), "^[^" + prop("Split at") + "]*" + prop("Split at"), "") : ""
 
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!