topic Escape Special Characters - XML in Talend Studio

Escape Special Characters - XML

RA6 — Sat, 16 Nov 2024 09:17:39 GMT

In my tmap, i am concatenating some txmlmap, it appears correctly in the tlog but not in xml file generated :

Expression builder where i am concatenating the xml with type "List":

Displaying correctly in tlog :

Xml file generated :

Is there a way to use the escape special characters?

Can someone advice or help me out?

Thank you.

Re: Escape Special Characters - XML

Anonymous — Thu, 14 Sep 2017 15:29:26 GMT

This looks like you are trying to insert XML within an XML structure (possibly within a tMap?). The problem you have here is that the tMap will interpret the String XML you are creating as a String. It is quite rightly escaping the content so that it will not break the XML structure you are inserting it into.

What you can do to get round this is to put a value to replace (maybe something like "**REPLACE**") into the XML field where you want to insert the XML you are writing as a String. Once the main XML is built, use a tConvertType component to convert the XML Document to a String. Then use String replace functionality to replace the "**REPLACE**" value with your String XML. The (after removing the XML Header) use a tConvertType component to convert the modified String XML to an XML Document.

It is a bit fiddly, but works quite effectively if you want to add XML sections to an existing XML document.