topic Re: CDATA, how to retrieve xml??? in Talend Studio

CDATA, how to retrieve xml???

Char — Wed, 06 Aug 2014 20:29:30 GMT

I am new to Talend and I have been struggling with a response message where the entire xml message has been wrapped by a CDATA tag.
Is there a component in Talend that I can use or do I need to write some java to get down to the xml tags within the message??
Any assistance would be greatly appreciated!

Re: CDATA, how to retrieve xml???

Anonymous — Fri, 08 Aug 2014 04:44:42 GMT

Hi,
Please see a related forum https://community.talend.com/t5/Data-Quality-Preparation-and/Issue-reading-XML-using-tfileInputXml/td-p/115384
Best regards
Sabrina

Re: CDATA, how to retrieve xml???

Char — Fri, 08 Aug 2014 13:09:16 GMT

Thanks Sabrina, I've already looked at the post you are referring to and tried using tFileInputRegex but was unsuccessful.
Because my response message I'm receiving is wrapped entirely by CDATA, I'm not sure what is the best output method.
Schema for the response message is defined as one large string. If I set my output as XML, I'm getting some extra lines added (xml version, root, row).
If I set my output to CSV, the data looks more useable, but I don't know how to have this data behave more like xml.
I've attached the two output files for comparison.
LMSoutxml.txt.txtLMSoutcsv.txt.txt