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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MAnywar
Contributor III
Contributor III

Replacing Special Characters for xml.

I have the out below being printing by xmlMAP after mapping, anybody could help on how I can get retain the xml tags. ("< "and ">")

​<provision>

<code>&lt;coding&gt;&lt;system value="urn:oid:2.16.840.1.113883.3.1937.777.24.5.3"/&gt;&lt;code value="2.16.840.1.113883.3.1937.777.24.5.3.6"/&gt&lt;code value="2.16.840.1.113883.3.1937.777.24.5.3.26"/&gt;&lt;display value="Rekontaktierung_Ergaenzungen"/&gt;&lt;/coding&gt;</code>

</provision>

​I have tried to use

StringHandling.EREPLACE(StringHandling.EREPLACE(row32.print, "&lt;" ,"<" ), "&gt;" , ">")

 

 but no success.

Thank you so much.

Job segment

Row10 is the source of the xml data. that I am further mapping to another recordset, which would result into a bigger xml file.

Job segment.

0695b00000ht6iVAAQ.png

Labels (3)
1 Reply
anselmopeixoto
Partner - Creator III
Partner - Creator III

Hello @Michael Anywar​ 

 

Your code is correct.

 

I've tried it and it should produce the following result (although there is a "&gt" on the result caused by a lacking semicolon):

 

<provision><code><coding><system value="urn:oid:2.16.840.1.113883.3.1937.777.24.5.3"/><code value="2.16.840.1.113883.3.1937.777.24.5.3.6"/&gt<code value="2.16.840.1.113883.3.1937.777.24.5.3.26"/><display value="Rekontaktierung_Ergaenzungen"/></coding></code></provision>

 

Could you show how it is defined inside your mapping component?