Skip to main content
Question

Formula Needed to Selectively List Characters Between Other Characters

  • September 24, 2019
  • 0 replies
  • 21 views
Forum|alt.badge.img+6
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 do items?

For example, for a record that contains:

_ Make bed
_ Buy yogurt
Items purchased online (9/24 3PM)
X Clean out fridge
Returned phonecalls (9/24 2PM)
_ Take out trash

I'd like have to another field that looks at my first field and selectively lists:

_ Make bed
_ Buy yogurt
_ Take out trash

Thank you!

------------------------------
Amber Amber
------------------------------
This topic has been closed for replies.

EverettPatterso
Forum|alt.badge.img+10
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
------------------------------
Terms & ConditionsAccessibility statement