Prev: add words to auto complete? Maybe?
Next: attachments
From: Paul Carlin Paul on 22 Feb 2010 20:59
I really am trying to learn this stuff, but I haven't programmed anything
since my TRS-80 Basic days and I'm a bit overwhelmed.

I want to extract text from Edit Decision Lists so that I have a list of
shots used in a film. Here is an example of one event of an EDL:

002 TAPE004 V C 04:45:22:06 04:45:24:14 02:00:08:00 02:00:10:08
FROM CLIP NAME: 7C-4_B_
DLEDL: PATH: /raids/luc_1/bun/reel_02/oscans/1222/bun_7c_4_b_02/2048x1556/

The text that follows "FROM CLIP NAME:" is the name of the clip that I want
to extract so that I have a document on only clip names like this (for
example)...

7C-4_B_
8A-1_A
12_B-11_A

And I'd like to modify this same macro to extract other items, like the
PATH: of each clip. At some point I will combine them into one awesome macro
that does it all making a table... but I can't even get started.

Thanks for any help with this.
From: macropod on 22 Feb 2010 22:52
Hi Paul,

Try using Find/Replace with the 'use wildcards' option checked, and:
Find = (*^13FROM CLIP NAME: )([!^13]{1,})(^13DLEDL: PATH: )([!^13]{1,})^13
Replace = \2^t\4^p

This should return both the clip name and its path, separated by a tab.

--
Cheers
macropod
[Microsoft MVP - Word]


"Paul Carlin" <Paul Carlin(a)discussions.microsoft.com> wrote in message news:5A943572-CC3E-43B3-AAD0-89219E557DB6(a)microsoft.com...
>I really am trying to learn this stuff, but I haven't programmed anything
> since my TRS-80 Basic days and I'm a bit overwhelmed.
>
> I want to extract text from Edit Decision Lists so that I have a list of
> shots used in a film. Here is an example of one event of an EDL:
>
> 002 TAPE004 V C 04:45:22:06 04:45:24:14 02:00:08:00 02:00:10:08
> FROM CLIP NAME: 7C-4_B_
> DLEDL: PATH: /raids/luc_1/bun/reel_02/oscans/1222/bun_7c_4_b_02/2048x1556/
>
> The text that follows "FROM CLIP NAME:" is the name of the clip that I want
> to extract so that I have a document on only clip names like this (for
> example)...
>
> 7C-4_B_
> 8A-1_A
> 12_B-11_A
>
> And I'd like to modify this same macro to extract other items, like the
> PATH: of each clip. At some point I will combine them into one awesome macro
> that does it all making a table... but I can't even get started.
>
> Thanks for any help with this.
From: Doug Robbins - Word MVP on 23 Feb 2010 00:31
To help you understand Macropod's suggestion, see the article "Finding and
replacing characters using wildcards” at:

http://www.word.mvps.org/FAQs/General/UsingWildcards.htm


--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Paul Carlin" <Paul Carlin(a)discussions.microsoft.com> wrote in message
news:5A943572-CC3E-43B3-AAD0-89219E557DB6(a)microsoft.com...
>I really am trying to learn this stuff, but I haven't programmed anything
> since my TRS-80 Basic days and I'm a bit overwhelmed.
>
> I want to extract text from Edit Decision Lists so that I have a list of
> shots used in a film. Here is an example of one event of an EDL:
>
> 002 TAPE004 V C 04:45:22:06 04:45:24:14 02:00:08:00
> 02:00:10:08
> FROM CLIP NAME: 7C-4_B_
> DLEDL: PATH: /raids/luc_1/bun/reel_02/oscans/1222/bun_7c_4_b_02/2048x1556/
>
> The text that follows "FROM CLIP NAME:" is the name of the clip that I
> want
> to extract so that I have a document on only clip names like this (for
> example)...
>
> 7C-4_B_
> 8A-1_A
> 12_B-11_A
>
> And I'd like to modify this same macro to extract other items, like the
> PATH: of each clip. At some point I will combine them into one awesome
> macro
> that does it all making a table... but I can't even get started.
>
> Thanks for any help with this.

From: Paul Carlin on 3 Mar 2010 00:54
Thanks for all the help. I got it to work.

 | 
Pages: 1
Prev: add words to auto complete? Maybe?
Next: attachments