SSDN - NULL string, replace with proper nillable element

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

JJJ JJJ

Subject: NULL string, replace with proper nillable element
Author: JJJ JJJ
Date: 24 Oct 2005 10:24 AM

Hi
We have an old XML file, which needs to be transformed using XSLT.
Due to the way it was originally implemented each time a NULL element value is sent over it is sent over tas the string NULL.
What I'd like to do is each time an element has a value of NULL it should be replaced so:
<a>NULL</a>
<b>NULL</b>

would become:
<a></a>
<b></b>

The problem is that this happens in multiple elements/nodes so do I have to do an if test for every dingle select/element or is there a quicker way ?

Thanks.

(Deleted User)

Subject: NULL string, replace with proper nillable element
Author: (Deleted User)
Date: 24 Oct 2005 12:03 PM

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
<xsl:apply-templates select="*"/>
</xsl:template>

<xsl:template match="@*|*">
<xsl:choose>
<xsl:when test="normalize(text())='NULL'">
<xsl:copy>
<xsl:apply-templates select="@*|*"/>
</xsl:copy>
</xsl:when>
<xsl:otherwise>
<xsl:copy>
<xsl:apply-templates select="text()|@*|*"/>
</xsl:copy>
</xsl:otherwise>
</xsl:choose>
</xsl:template>

</xsl:stylesheet>

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.