HTML to XML transform

parag.s.27 · Post by **parag.s.27** » Thu Jul 06, 2006 8:47 am

Hi All,

I have one situation...where we have to take some data from a HTML page and transform it to an XML output....how can we do that in server job....

i have DS version as 7.5.1.A..

Thanks in advance

kduke · Post by **kduke** » Thu Jul 06, 2006 5:59 pm

Probably manually. By searching for the tags you want to change. I would think stage variables would be needed to aggregate a field by catenating values across lines.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 06, 2006 9:10 pm

DataStage is really row-oriented. Perhaps you could re-format the page into a single row (or at least some appropriate chunk between starting and ending tags) then use appropriate techniques (for example lots of Ereplace() invocations in a routine) to substitute tags and the like.

Do you have the conversion fully specified?

parag.s.27 · Post by **parag.s.27** » Fri Jul 07, 2006 2:27 am

Hi All,

Thanks for the reply.....
I've found afreeware that converts HTML to XML.....now i'll need to transform this XML as per my need and again generate a XML...

I just wanted to know that...in my server edition i do not have a folder stage...so by using XML input, XML transformer, and XML Output can i do this...

Thanks in Advance

chulett · Post by **chulett** » Fri Jul 07, 2006 6:37 am

parag.s.27 wrote:I just wanted to know that...in my server edition i do not have a folder stage...so by using XML input, XML transformer, and XML Output can i do this...

You have a Folder stage - or you sure should have as it's not one of the optional plug-in stages. Should be under the File section of the Designer palette and under Stage Types / Server / File via the Manager.

And no, you don't 'need' the Folder stage to do this, the XML Input stage could happily use the URL method to read a single file if needed.