Hi all,

I have data that has embedded apostrophes and I need to replace them with blanks. I use the following code:

<xsl:value-of select="translate($desc, '#x27;', ' ')"/>

or

<xsl:value-of select="translate($desc, '&apos;', ' ')"/>

or

<xsl:value-of select="translate($desc, '&quot;', ' ')"/>

and the result is the same:

javax.xml.transform.TransformerException: javax.xml.transform.TransformerException: misquoted literal... expected single quote!

Has anyone run into this before? How do I translate a single quote/apostrophe?

Thanks,
Tom

In 2.0:

<xsl:value-of select="translate($desc, '''', ' ')"/>

In 1.0:

<xsl:value-of select='translate($desc, "&apos;", " ")'/>

or

<xsl:variable name="apos">'</xsl:variable>
<xsl:value-of select="translate($desc, $apos, ' ')"/>

Always remember that XML entity and character references are expanded before the XPath parser kicks in, so they can't be used to escape something that's significant to XPath.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thanks for the input. That solved the problem.