Script to parse data and create new records in three other tables
Hi. Starting a new post on this topic since my old one kind of morphed into something else.
I need a process that parses text stored in a field in one table and writes various parsed data elements to new records created in three other tables. There's a little more to it than that but that's the main purpose.
Here's a URL to a spreadsheet that contains a detailed description of what I'm trying to do.
If it looks interesting and you'd like to help me figure this out, let me know. Complex scripts are way over my head.