How to convert xml tag $lt; $gt to < and > ?

Seven Stars

How to convert xml tag $lt; $gt to < and > ?

Hello, its me again, I have my  output XML file getting by tXmlMap and tHttpRequest  , but my xml file have not the tag < and > or ' , for exemple , how can i convert it ?

<?xml version="1.0" encoding="UTF-8"?>
<root>
<row>
<ows_Title>a_Title</ows_Title>
<ResponseContent>&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
&lt;?mso-infoPathSolution name=&quot;urn:schemas-microsoft-com:office:infopath&quot; solutionVersion=&quot;0.0.0.394&quot; productVersion=&quot;14.0.0.0&quot; PIVersion=&quot;1.0.0.0&quot; href=&quot&lt;?mso-application progid=&quot;InfoPath.Document&quot; versionProgid=&quot;InfoPath.Document.3&quot;?&gt;
&lt;?mso-infoPath-file-attachment-present?&gt;


Accepted Solutions
Highlighted
Eight Stars

Re: How to convert xml tag $lt; $gt to < and > ?

I've always used StringEscapeUtils.unescapeHtml for this purpose.

View solution in original post


All Replies
Forteen Stars

Re: How to convert xml tag $lt; $gt to < and > ?

You can use StringHandling.EREPLACE function in tXMLMap component

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Eight Stars

Re: How to convert xml tag $lt; $gt to < and > ?

I've always used StringEscapeUtils.unescapeHtml for this purpose.

View solution in original post

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog