Yes, this looks like it works.
So, how is the performance now.. is it any better?
Yes, I'm using the "XML to JSON" converting process for this solution. The problem was that the XML code being sent to the process must be whitewashed from all forbidden JSON characters first.
1 of 1 people found this helpful
I have shamelessly borrowed this xslt from stack overflow and tested on the sample you posted earlier. Seems to be working fine. You may need to adjust the list of allowed characters for your use case.
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>
<xsl:template match="node() | @*">
<xsl:apply-templates select="node() | @*"/>
translate(., $vAllowedSymbols, ''),
Hope it helps,
OK, yeah. That also works, deciding on what characters to only allow instead of removing specific characters.