Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Char
Contributor
Contributor

CDATA, how to retrieve xml???

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!
Labels (4)
2 Replies
Anonymous
Not applicable

Char
Contributor
Contributor
Author

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