Page 1 of 1

Is it Possible to read a word file in Datastage Server jobs

Posted: Thu Apr 12, 2012 4:03 pm
by Jagan617
Hi,

Is it possible to read a word document and write the contents in different txt file through a datastage job ? I think it is not possible. Does anybody tried or is there a way to read a word document through the DS job? please assist me

Posted: Thu Apr 12, 2012 4:06 pm
by ray.wurlod
Your "no" is correct, unless you completely understand the layout of the Word file (tip: nobody does).

However, your DataStage might invoke some VBA script that performs that task as a before-job subroutine, so that the DataStage job itself can then process the text file.

Posted: Thu Apr 12, 2012 4:26 pm
by Jagan617
Thanks Ray for the prompt Response

Posted: Thu Apr 12, 2012 4:40 pm
by qt_ky
Of course you can save the Word file as a txt or similar format to begin with then read it without much effort.

Is the newer docx format any easier to work with? Is it XML based?

What about the MS OLD DB stage, would it help or not?