Solved

In PowerBuilder, how can i hide those tag in xml export file when there is a null value being returned from the datawindow?  E.g from the script below, <Name/><Initials>SRM</Initials>,  hide <Name/>

Posted on 2009-04-06
3
1,114 Views
Last Modified: 2013-11-19
In PowerBuilder, how can i hide those tag in xml export file when there is a null value being returned from the datawindow?  
E.g from the script below, <Name/><Initials>SRM</Initials>,  i wish to hide <Name/> for being displayed in the XML file

Let me further explain my problems encountered in Powerbuilder Exported XML

Sample Scenario as below:
<Name>Johnson<MarriageDate>2001-09-09</MarriageDate></Name>
<Name>Marry<MarriageDate/></Name>
<Name>Jeannie<MarriageDate>2008-08-08</MarriageDate></Name>

Because MarriageDate element is expecting a date value, passing empty element <MarriageDate/> will cause validation error when importing the exported XML. Is there any way/workaround to resolve this to have output XML like sample below?

<Name>Johnson<MarriageDate>2001-09-09</MarriageDate></Name>
<Name>Marry</Name>
<Name>Jeannie<MarriageDate>2008-08-08</MarriageDate></Name>

0
Comment
Question by:orinauts
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
abel earned 500 total points
ID: 24174857
The simplest method to remove empty elements is to use XSLT. I don't know enough of PowerBuilder to do that by code, but if you know the basics, it seems that this article shows you how to do it: http://www.sybase.com/detail?id=1013844

Then I can help you with the XSLT part, which looks like this:

-- Abel --

<!-- ----------------------------------------------- -->
<!-- XSLT part, copies all except the empty elements -->
<!-- ----------------------------------------------- -->
<?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"/>
    
    <!-- copy template, copies every element/node/text/attr -->
    <xsl:template match="node()|@*">
        <xsl:copy>
            <xsl:apply-templates select="node()|@*" />
        </xsl:copy>
    </xsl:template>
 
    <!-- a "delete"-template to remove all contents of diffgr:before -->
    <xsl:template match="*[not(text())]" />
    
</xsl:stylesheet>
 
 
 
<!-- ----------------------------------------------- -->
<!-- your input (amended with a root to make it XML) -->
<!-- ----------------------------------------------- -->
<?xml version="1.0" encoding="utf-8"?>
<root>
    <Name>Johnson<MarriageDate>2001-09-09</MarriageDate></Name>
    <Name>Marry<MarriageDate/></Name>
    <Name>Jeannie<MarriageDate>2008-08-08</MarriageDate></Name>
</root>
 
 
 
<!-- --------------------------------- -->
<!-- the output after run against XSLT -->
<!-- --------------------------------- -->
<?xml version="1.0" encoding="utf-8"?>
<root>
    <Name>Johnson<MarriageDate>2001-09-09</MarriageDate></Name>
    <Name>Marry</Name>
    <Name>Jeannie<MarriageDate>2008-08-08</MarriageDate></Name>
</root>

Open in new window

0
 
LVL 39

Expert Comment

by:abel
ID: 24174863
sorry for that wrong comment about diffgr:before, that was from something else. But it *is* a delete template and it removes all elements that do not contain any text content.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preface In the first article: A Better Website Login System (http://www.experts-exchange.com/A_2902.html) I introduced the EE Collaborative Login System and its intended purpose. In this article I will discuss some of the design consideratio…
I will show you how to create a ASP.NET Captcha control without using any HTTP HANDELRS or what so ever. you can easily plug it into your web pages. For Example a = 2 + 3 (where 2 and 3 are 2 random numbers) Session("Answer") = 5 then we…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question