Forum Discussion
EverettPatterso
6 years agoQrew Captain
Not tested, but try this in a formula text field. Change [Text4] to your field name, you will need to add more lines if you want the list to go above 6 items.
------------------------------
Everett Patterson
------------------------------
List("\n", If(Contains(Trim(Part([Text4], 1,"\n")), "_"), Trim(Part([Text4], 1,"\n")), ""), If(Contains(Trim(Part([Text4], 3,"\n")), "_"), Trim(Part([Text4], 3,"\n")), ""), If(Contains(Trim(Part([Text4], 5,"\n")), "_"), Trim(Part([Text4], 5,"\n")), ""), If(Contains(Trim(Part([Text4], 7,"\n")), "_"), Trim(Part([Text4], 7,"\n")), ""), If(Contains(Trim(Part([Text4], 9,"\n")), "_"), Trim(Part([Text4], 9,"\n")), ""), If(Contains(Trim(Part([Text4], 11,"\n")), "_"), Trim(Part([Text4], 11,"\n")), "") )
------------------------------
Everett Patterson
------------------------------