How to use replace statement is XSLT?

EDN Admin · Jan 31, 2012

Fiel name : CDS.xml
<?xml version="1.0" encoding="ISO-8859-1"?> <catalog> <cd> <package>A</package> <id>1</id> <title>Empire Burlesque</title> <artist>Bob Dylan</artist> <country>USA</country> <company>Columbia</company>
<price>10.90</price> <year>1985</year> </cd> <cd> <package>A</package> <id>1</id> <title>Hide your heart</title> <artist>Bonnie Tyler</artist> <country>UK</country>
<company>CBS Records</company> <price>9.90</price> <year>1988</year> </cd> <cd> <package>B</package> <id>1</id> <title>Greatest Hits</title> <artist>Dolly Parton</artist>
<country>USA</country> <company>RCA</company> <price>9.90</price> <year>1982</year> </cd> <cd> <package>B</package> <id>2</id> <title>Still got the blues</title>
<artist>Gary Moore</artist> <country>UK</country> <company>Virgin records</company> <price>10.20</price> <year>1990</year> </cd> <cd> <package>B</package> <id>3</id>
<title>Eros</title> <artist>Eros Ramazzotti</artist> <country>EU</country> <company>BMG</company> <price>9.90</price> <year>1997</year> </cd> <cd> <package>A</package>
<id>2</id> <title>One night only</title> <artist>Bee Gees</artist> <country>UK</country> <company>Polydor</company> <price>10.90</price> <year>1998</year> </cd> <cd>
<package>A</package> <id>3</id> <title>Sylvias Mother</title> <artist>Dr.Hook</artist> <country>UK</country> <company>CBS</company> <price>8.10</price> <year>1973</year>
</cd> <cd> <package>A</package> <id>4</id> <title>Maggie May</title> <artist>Rod Stewart</artist> <country>UK</country> <company>Pickwick</company> <price>8.50</price>
<year>1990</year> </cd> <cd> <package>A</package> <id>2</id> <title>Romanza</title> <artist>Andrea Bocelli</artist> <country>EU</country> <company>Polydor</company>
<price>10.80</price> <year>1996</year> </cd> </catalog>
File Name : Cds.xsl
<?xml version="1.0" encoding="ISO-8859-1"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform <xsl:template match="/ <html> <body> My CD Collection <table border="1
<tr bgcolor="#9acd32 <th>Package</th> <th>ID</th> <th>Title</th> <th>Artist</th> </tr> <xsl:for-each select="catalog/cd <tr> <td><xsl:value-of select="package"/></td>
<td><xsl:value-of select="id"/></td> <td><xsl:value-of select="title"/></td> <td><xsl:value-of select="artist"/></td> </tr> </xsl:for-each> </table> </body> </html> </xsl:template>
</xsl:stylesheet>
This is the out put
<?xml version="1.0" encoding="UTF-16"?> 
<catalog> 
<cd> 
<package>A</package> 
<id>1</id> 
<title>Empire Burlesque</title> 
<artist>Bob Dylan</artist> 
</cd> 
<cd> 
<package>A</package> 
<id>1</id> 
 
<title>Hide your heart</title> 
<artist>Bonnie Tyler</artist> 
</cd> 
<cd> 
<package>B</package> 
<id>1</id> 
<title>Greatest Hits</title> 
<artist>Dolly Parton</artist> 
</cd> 
<cd> 
<package>B</package> 
 
<id>2</id> 
<title>Still got the blues</title> 
<artist>Gary Moore</artist> 
</cd> 
<cd> 
<package>B</package> 
<id>3</id> 
<title>Eros</title> 
<artist>Eros Ramazzotti</artist> 
</cd> 
 
<cd> 
<package>A</package> 
<id>2</id> 
<title>One night only</title> 
<artist>Bee Gees</artist> 
</cd> 
<cd> 
<package>A</package> 
<id>3</id> 
<title>Sylvias Mother</title> 
 
<artist>Dr.Hook</artist> 
</cd> 
<cd> 
<package>A</package> 
<id>4</id> 
<title>Maggie May</title> 
<artist>Rod Stewart</artist> 
</cd> 
<cd> 
<package>A</package> 
<id>2</id> 
 
<title>Romanza</title> 
<artist>Andrea Bocelli</artist> 
</cd> 
</catalog> 
 

---------------------------------------------------------------------------------
Wht i need is, i need to replace "ids"(of output) with "New IDs" of below xml
i have a new file called "New_IDs.xml"
<?xml version="1.0" encoding="ISO-8859-1"?> <catalog> <ids> <package>A</package> <id>1</id> <newId>A-1001</newId> </ids> <ids> <package>A</package> <id>2</id> <newId>A-1002</newId>
</ids> <ids> <package>A</package> <id>3</id> <newId>A-1003</newId> </ids> <ids> <package>A</package> <id>4</id> <newId>A-1004</newId> </ids> <ids> <package>B</package>
<id>1</id> <newId>B-1001</newId> </ids> <ids> <package>B</package> <id>2</id> <newId>B-1002</newId> </ids> <ids> <package>B</package> <id>3</id> <newId>B-1003</newId>
</ids> <ids> <package>B</package> <id>4</id> <newId>B-1005</newId> </ids> </catalog>
Hoping your help 

View the full article

How to use replace statement is XSLT?

EDN Admin

Well-known member

Similar threads