Need help extracting text from EDLs

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.
0
Utf
2/23/2010 1:59:01 AM
word.vba.general 1023 articles. 1 followers. Follow

3 Replies
685 Views

Similar Articles

[PageSpeed] 51

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@discussions.microsoft.com> wrote in message news:5A943572-CC3E-43B3-AAD0-89219E557DB6@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.
0
macropod
2/23/2010 3:52:24 AM
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@discussions.microsoft.com> wrote in message 
news:5A943572-CC3E-43B3-AAD0-89219E557DB6@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. 

0
Doug
2/23/2010 5:31:05 AM
Thanks for all the help.  I got it to work.

0
Utf
3/3/2010 5:54:01 AM
Reply:

Similar Artilces: