Forum Discussion
MarkShnier__You
Qrew Legend
4 years agoTry this. It tested OK.
var text One = Trim(Part([My Prepend text field],2,"["));
var text Two = Trim(Part([My Prepend text field],3,"["));
var text Three = Trim(Part([My Prepend text field],4,"["));
List ("\n",
If($One<>"", "[" & $One),
If($Two<>"", "[" & $Two),
If($Three<>"", "[" & $Three))
Original data in field.
[JAN-26-22 Mark Shnier (YQC)] Shep
[JAN-26-22 Mark Shnier (YQC)] Moe
[JAN-26-22 Mark Shnier (YQC)] Larry
[JAN-26-22 Mark Shnier (YQC)] Curley
Formula generates this result.
[JAN-26-22 Mark Shnier (YQC)] Shep
[JAN-26-22 Mark Shnier (YQC)] Moe
[JAN-26-22 Mark Shnier (YQC)] Larry
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text One = Trim(Part([My Prepend text field],2,"["));
var text Two = Trim(Part([My Prepend text field],3,"["));
var text Three = Trim(Part([My Prepend text field],4,"["));
List ("\n",
If($One<>"", "[" & $One),
If($Two<>"", "[" & $Two),
If($Three<>"", "[" & $Three))
Original data in field.
[JAN-26-22 Mark Shnier (YQC)] Shep
[JAN-26-22 Mark Shnier (YQC)] Moe
[JAN-26-22 Mark Shnier (YQC)] Larry
[JAN-26-22 Mark Shnier (YQC)] Curley
Formula generates this result.
[JAN-26-22 Mark Shnier (YQC)] Shep
[JAN-26-22 Mark Shnier (YQC)] Moe
[JAN-26-22 Mark Shnier (YQC)] Larry
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
GV
4 years agoQrew Member
Many thanks Mark. That worked just fine.