Agreed with @Bill_French2 re: subtables and/or JSON.
at the moment my priority is figuring out how to just extract the dates and remove the commentary.
So for the moment, for the extracting–maybe try regex? The below embed may do it for you, but in case it doesn’t, I’ve also included some resources.
RESOURCES
For Learning:
- RegexOne - Learn Regular Expressions - Lesson 1: An Introduction, and the ABCs
- (Disclaimer: I didn’t go through the whole tutorial here, but IIRC have used it for occasional concepts I’ve had trouble grasping)
- Regular Expression Tutorial - Learn How to Use Regular Expressions (regular-expressions.info)
- This one gets into more complex concepts, but fair warning: it makes my brain hurt sometimes, haha. But then I’ve never properly learned Regex…I just sort of…play till I find the right one
- This one gets into more complex concepts, but fair warning: it makes my brain hurt sometimes, haha. But then I’ve never properly learned Regex…I just sort of…play till I find the right one
For Testing:
- I believe Coda uses a system most similar to the JavaScript flavor (? someone correct if I’m wrong), so make sure that’s selected when using either of these
Coda-Specific:
- Coda-specific testing: Coda Regex Formulas Tool - Showcase / Tips and Hacks - Coda Maker Community
- @Eric_Koleda’s Pack that I use on a semi-regular basis: Regex+ Pack, extend Coda with Regex+ - Coda