Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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?