How do I show a finite number of entries from a reference append field?

Try 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
------------------------------