#1 2009-10-28 08:48:46

james73
Member
Company: Private
Registered: 2008-07-23
Posts: 44

XML string to a file

I'm tyring to find the best way to extract rows from a column, where each row is a text string of XML data.  I'm trying to extract each row to an XML file and then load it into a new table.  Is this possible, or is there a better way to reading the XML data from rows?

thanks


When context.Life = "grownup" trigger tMarriage; on component OK iterate tChildren; on subjob OK generate random extract from tBankAccount (tLoop until balance = 0)

Offline

#2 2009-10-28 09:08:00

shong
Talend team
Registered: 2007-08-29
Posts: 10357
Website

Re: XML string to a file

Hello
Yes, you can use tExtractXMLField component to exract data from a xml row. See a related [Forum, topic 6670] Processing input xml in a talend job

Best regards

          shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

Board footer

Powered by FluxBB