Extract Data From word

[KH75]

Hi

I have lots of Ms word files in a folder. I want to extract E-Mail address from these word file. Is it possible through SSIS

Thanks in advance

 

[dhulbert]

Maybe

Depending on a whole load of factors, What word version? If it's a later version is the file a docx file or .doc
How is the address held?
Is it the only text in the document?
Is it im the middle of a whole load of text?
Is it in a table in a specific field.

You can load a word document and do some manupulation to the text but you wil need to know exactly how to find the e-mail address in the file.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[KH75]

Hi

Thanks for reply


What word version? If it's a later version is the file a docx file or .doc
These document are mixed with *.doc and *.docx extesion

How is the address held?
Address usually at the top of first page in middle

Is it the only text in the document?
No

Is it im the middle of a whole load of text?
what is im ?

Is it in a table in a specific field.
yes I need it in a table from ms word document

Thanks