Does anyone know a way to separate items from a concatenated string?
I have a table that I’ve used to make a schedule of events for a conference. Each presenter makes multiple appearances. Using Zapier and WebMerge I plan to produce a print-ready manifest for each presenter that will show their personalized schedule, along with hotel, flight, and contact information from other tables.
Problem is, when I look up the start time of their presentations I get ALL the start times in a concatenated string like this:
1/13/2017 10:35am, 1/14/2017 9:40am, 1/14/2017 12:20pm
I’d like a formula that basically says “find and display first item from string”, “find and display second item from string” etc… Then I could create fields for “Start Time 1,” “Start Time 2”, match them up with corresponding End Time fields, and get it over to WebMerge and in print.
Many many thanks to anyone who can help point me in the right direction here. :eyeglasses:
