Generic XSLT Search and Replace template

Question

I am trying to find  before re-inventing  a  simple  XSLT template that will take ANY xml document  find ALL text elements within that XML and replace all   with      I m doing a  SELECT     FOR XML  from SQL and then  saving  that XML for later insertion back into SQL   After doing the SELECT FOR XML  I would like to make all     s in that text before processing it further   That way  after being integrated into other XML  which may not need such a replacement  the text will already be  SQL Safe      Any suggestions on how to best accomplish this would be greatly appreciated

User · Accepted Answer

Here s one way in XSLT 2   lt  xml version  1 0  encoding  UTF-8   gt   lt xsl stylesheet version  2 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt     lt xsl template match     node    gt       lt xsl copy gt         lt xsl apply-templates select     node     gt       lt  xsl copy gt     lt  xsl template gt     lt xsl template match  text    gt       lt xsl value-of select  translate     amp quot           gt     lt  xsl template gt   lt  xsl stylesheet gt    Doing it in XSLT1 is a little more problematic as it s hard to get a literal containing a single apostrophe  so you have to resort to a variable    lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt     lt xsl template match     node    gt       lt xsl copy gt         lt xsl apply-templates select     node     gt       lt  xsl copy gt     lt  xsl template gt     lt xsl variable name  apos  gt   lt  xsl variable gt     lt xsl template match  text    gt       lt xsl value-of select  translate     amp quot    apos    gt     lt  xsl template gt   lt  xsl stylesheet gt

[sql] Generic XSLT Search and Replace template

Examples related to sql

Examples related to xslt