hbkana2ran
New Member
I have such XML\[code\]<?xml version="1.0" encoding="utf-8"?><?xml-stylesheet type="text/xsl" href="http://stackoverflow.com/questions/11540705/do.xsl"?><catalog> <cd> <title_>Empire Burlesque</title_> <artist>Bobby</artist> <company>Columbia</company> </cd> <cd> <title_>Shirt2</title_> <artist>Bobby</artist> <company>Columbia2</company> </cd> <cd> <title_>Fingers</title_> <artist>Bobby</artist> <company>Columbia3</company> </cd> <cd> <title_>Zip1</title_> <artist>Bobby</artist> <company>---</company> </cd> <cd> <title_>Zip2</title_> <artist>Bobby</artist> <company>---</company> </cd></catalog>\[/code\]I need to replace --- with previous meaningful data - Columbia3I do next\[code\]<?xml version="1.0" encoding="utf-8"?><xsl:stylesheet version="1.0"xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl
utput method="html" version="4.0" encoding="utf-8" indent="yes"/><xsl:template match="/"> <html> <body> <h2>My CD Collection</h2> <table border="1"> <tr bgcolor="#9acd32"> <th>Title</th> <th>Artist</th> </tr> <xsl:for-each select="catalog/cd"> <tr> <td><xsl:value-of select="title_"/></td> <td><xsl:value-of select="artist"/></td> <td> <xsl:variable name="NotStarted" select="preceding-sibling::cd[1]/company" /> <xsl:choose> <xsl:when test="company != '---'"> <xsl:value-of select="company"/> </xsl:when> <xsltherwise> <xsl:copy-of select="$NotStarted" /> </xsltherwise> </xsl:choose> </td> </tr> </xsl:for-each> </table> </body> </html></xsl:template></xsl:stylesheet> \[/code\]As expected i got next html\[code\]Title ArtistEmpire Burlesque Bobby ColumbiaShirt2 Bobby Columbia2Fingers Bobby Columbia3Zip1 Bobby Columbia3Zip2 Bobby ---\[/code\]How i can iterate back to get last meaningful string to replace with or any other way? Thanks.
utput method="html" version="4.0" encoding="utf-8" indent="yes"/><xsl:template match="/"> <html> <body> <h2>My CD Collection</h2> <table border="1"> <tr bgcolor="#9acd32"> <th>Title</th> <th>Artist</th> </tr> <xsl:for-each select="catalog/cd"> <tr> <td><xsl:value-of select="title_"/></td> <td><xsl:value-of select="artist"/></td> <td> <xsl:variable name="NotStarted" select="preceding-sibling::cd[1]/company" /> <xsl:choose> <xsl:when test="company != '---'"> <xsl:value-of select="company"/> </xsl:when> <xsltherwise> <xsl:copy-of select="$NotStarted" /> </xsltherwise> </xsl:choose> </td> </tr> </xsl:for-each> </table> </body> </html></xsl:template></xsl:stylesheet> \[/code\]As expected i got next html\[code\]Title ArtistEmpire Burlesque Bobby ColumbiaShirt2 Bobby Columbia2Fingers Bobby Columbia3Zip1 Bobby Columbia3Zip2 Bobby ---\[/code\]How i can iterate back to get last meaningful string to replace with or any other way? Thanks.