I'm so sorry to ask this if it's too basic as I believe it's an error with my REGEX but I have the following formatted text:
01:00:04:00- 01:00:55:04 -Notes for the project. This needs to be copied etc
I have to place each of these into a Google sheet so I need the first timecode as one variable, the second timecode after the "-" as another variable, and all the text after the remaining "-" following the 2nd timecode as a 3rd variable so I can then paste each one into the proper slots in the Google Sheet.
For some reason my code is only copying the first 00:00 numbers of the timecode and not copying all of the text after the 2nd timecode slot and was wondering if anyone knows a simpler way to do this in KM?
Thank you so much for your help!