AnsweredAssumed Answered

Script to parse data and create new records in three other tables

Question asked by besmith1ca on Oct 5, 2014

Title

Script to parse data and create new records in three other tables

Post

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. 

https://www.dropbox.com/s/f88xhc5hveknpmh/FOLF%20Sript%20Plans.xlsx?dl=0

Thanks for looking.

Outcomes