Forum Discussion

AmberPollard's avatar
AmberPollard
Qrew Assistant Captain
6 years ago

Formula Needed to Selectively List Characters Between Other Characters

I keep a list of progress and to do items in a text field, some of the lines start with the underscore character to indicating they are a pending to do item. Is there a way to only list the pending to...
Formulas and functions
EverettPatterso's avatar
EverettPatterso
Qrew Captain
6 years ago
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. 

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