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

Jagan617 · Post by **Jagan617** » Thu Apr 12, 2012 4:03 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Apr 12, 2012 4:06 pm

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.

Jagan617 · Post by **Jagan617** » Thu Apr 12, 2012 4:26 pm

Thanks Ray for the prompt Response

qt_ky · Post by **qt_ky** » Thu Apr 12, 2012 4:40 pm

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?