Need help extracting text from EDLs

[Paul Carlin]

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.

 

[macropod]

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.

 

[Doug Robbins - Word MVP]

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]

Thanks for all the help. I got it to work.