text extraction
 

I was hoping to develop a macro that extracts specific values from
fairly well sturctured reports in MS Word (Roughly 1000 of them). I do
not expect any miracles, but was hoping to be able to pull out a few
specific values.

Simplified Example report format:

Review No: ########
Code: #####
Title: Aaaaaa
Type: ###

(text)

I could mostly likely key in on the field headings (e.g., Review No:)
and take the next 7 numbers. But I was hoping to run through the
documents with a little more flexibility.

Any feedback on this matter or available open-source or commercial
tools.

Thanks

text extraction
 

Hi Matt,

If the data you want to keep don't use the same paragraph style as the data
you want to delete, you could use a Word macro to go through the file,
deleting all paras in the unwanted styles.

That would leave just the data you want for copying & pasting into Excel.

Cheers


"Matt" wrote in message
oups.com...
I was hoping to develop a macro that extracts specific values from
fairly well sturctured reports in MS Word (Roughly 1000 of them). I do
not expect any miracles, but was hoping to be able to pull out a few
specific values.

Simplified Example report format:

Review No: ########
Code: #####
Title: Aaaaaa
Type: ###

(text)

I could mostly likely key in on the field headings (e.g., Review No:)
and take the next 7 numbers. But I was hoping to run through the
documents with a little more flexibility.

Any feedback on this matter or available open-source or commercial
tools.

Thanks

text extraction
 

You could have the macro search for the title, colon -and- space, then
have it jump to the end of the next word (ctrl+rt.arrow), instead o
always moving *-n-* characters past the title. That way would give
little flexability in the length of the selection.
-------------------------
Ben :cool

--
protonLea
-----------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...fo&userid=3209
View this thread: http://www.excelforum.com/showthread.php?threadid=53823