I have an Airtable that is populated from Jotform submissions. The Jotform has a configurable list that for someone to fill in their schedule for the week. The configurable list can’t be split in Jotform so I’m trying to split information in Airtable. I want all of the days of the week listed in the configurable list cell to be extracted in a Days Open column but can only figure out how to extract the first instance using regexextract.
For example the configurable list will come in as:
Day Open: Monday, Opening Date: 2025-06-16, Closing Date: 2025-10-27, Start Time: 09:00 AM, End Time: 02:00 PM
Day Open: Saturday, Opening Date: 2025-08-09, Closing Date: 2025-08-30, Start Time: 10:00 AM, End Time: 04:00 PM
and I want Monday, Saturday to show up in the days they are open.


