Timecode and Notes Segmentation Question

Questions & Suggestions
1

Hello All,

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!

2

You can refer to parts of a delimited string by one-based index

(index 0 holds the length of the array of parts)

Times Split.kmmacros (2.3 KB)

Keyboard Maestro Export
Keyboard Maestro Export986×1502 130 KB

1 Like
3

Ah that makes so much more sense! Thanks so much!

1 Like
4

See the Variable Arrays section (particularly How to Use Custom Array Delimiter) lower down on this page:

manual:Variables [Keyboard Maestro Wiki]

5

When you've got consistently-presented text you can go straight to substrings. Assuming your text is as above (separate lines), you know the first TP will be characters 1 through 11, the second 14 through 24, and the notes are 27 through to the end:

Substrings Demo 2.kmmacros (4.3 KB)

Substrings Demo 2
Substrings Demo 21322×1900 270 KB

6

Hey Matthew,

One more bite...

-Chris

Regex – Capture Time Codes and Notes v1.00.kmmacros (6.9 KB)
Keyboard Maestro Export