SFX Clipboard Filtering?

Questions & Suggestions
1

Hey everyone,

I'm trying to list out SFX into a formatted Excel sheet and have info like the following:

AS 107s15 REV SoundAS723
Start: 01:18:55:01

End: 01:19:11:03
Total: 00:00:16:02

AS 107s16 Rocket Launch01
Start: 01:19:11:03

End: 01:19:30:08
Total:00:00:19:05

I need to separately be able to copy

  1. the number/indicator following AS "107s16"
  2. The name following the AS "Rocket Launch01"
  3. Start Time: "01:19:11" - Just the first 3 number values
  4. End Time "01:19:30" - Just the first 3 number values

And put those in separate clipboards so I can paste them into the right locations in the Excel sheet. I'm having some trouble filtering this info from a named clipboard and was wondering if anyone knows how to? Thanks so much in advance!

2

This'll get you started. It does assume you only process one "text block" at a time, as shown in the first action. If you are going to copy multiple blocks, like in your post, you'll have to split them and process individually. If you are going to paste the output into a contiguous row of cells in the spreadsheet then enable the last action -- Excel treats tabs in a pasted text string as "and in the next cell paste...". If not then try one "Insert text by pasting" action for each variable rather than setting clipboards.

Field Separation Test.kmmacros (5.3 KB)

Image

Field Separation Test
Field Separation Test914×3450 441 KB

1 Like
3

@Nige_S this is so helpful thank you so so much!