Extracting specific data from inconsistant multiple word documents
On Mon, 22 Dec 2008 01:47:01 -0800, Matt Bennette
wrote:
Hi Guys,
I have about a 1000 word documents and need to extract all the email
addresses from them. Ideally the result would place the filename in column A
and the email address in column B. None of the documents are consistant in
format. I have got as far as listing the file names.
Many thanks.
There are ways of recognizing email addresses within text strings. For
example, depending on your data, you could look for the "@" character. Or
perhaps you could look for a string in which the "@" is followed by one or more
characters; then a ".", then a few more characters.
--ron
|