Comma (,) - .csv
Tabs (\t) - .tsv
Semi-colons (;)
Pipes (|) - .psv
Carets (^)
Tildes (~)
Tabs (\t) - .tsv
Semi-colons (;)
Pipes (|) - .psv
Carets (^)
Tildes (~)
Showing posts with label MISC. Show all posts
Showing posts with label MISC. Show all posts
Wednesday, May 4, 2016
Thursday, September 5, 2013
How do you transform XML into XHTML using XSLT?
1. Start with an XML document (books.xml).
2. Create an XSL stylesheet (books.xsl).
3. Keep both files at a specific location. Otherwise update the value of "href" tag with the absolute path of "books.xsl" in "books.xml".
4. Click the "books.xml" file to open in browser by default.
books.xml
--------------------------------------
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="books.xsl"?>
<catalog>
<book id="bk9781118013847">
<title>Beginning Perl</title>
<author>Curtis Ovid Poe</author>
<genre>Computer Programming</genre>
<publisher>Wiley / Wrox</publisher>
<price>31.99</price>
<publish_date>August 2012</publish_date>
<isbn>978-1-4571-2094-7</isbn>
<description>Perl's basics and best practices for Beginners</description>
</book>
<book id="bk9780596527242">
<title>Mastering Perl</title>
<author>Brian d Foy</author>
<genre>Computer Programming</genre>
<publisher>O'Reilly Media</publisher>
<price>31.99</price>
<publish_date>July 2007</publish_date>
<isbn>978-0-596-52724-2</isbn>
<description>Focuses on real-life problems of debugging, maintenance, configuration</description>
</book>
<book id="bk9780470556801">
<title>Perl and Apache</title>
<author>Adam McDaniel</author>
<genre>Computer Programming</genre>
<publisher>Wiley / Visual</publisher>
<price>34.99</price>
<publish_date>January 2011</publish_date>
<isbn>978-1-4571-3092-2</isbn>
<description>A visual blueprint for developing dynamic Web content</description>
</book>
</catalog>
books.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>
<h2>Book Details</h2>
<table border="1" style="width:70%;">
<tr bgcolor="#9acd32">
<th>Id</th>
<th>Title</th>
<th>Author</th>
<th>Price ($)</th>
<th>Publish Date</th>
<th>Genre</th>
<th>Description</th>
</tr>
<xsl:for-each select="catalog/book">
<xsl:sort select="@id"/>
<tr>
<td><xsl:value-of select="@id"/></td>
<td align="center"><xsl:value-of select="title"/></td>
<td><xsl:value-of select="author"/></td>
<td align="right"><b><xsl:value-of select="price"/></b></td>
<td><xsl:value-of select="publish_date"/></td>
<td><xsl:value-of select="genre"/></td>
<td align="justify"><xsl:value-of select="description"/></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
2. Create an XSL stylesheet (books.xsl).
3. Keep both files at a specific location. Otherwise update the value of "href" tag with the absolute path of "books.xsl" in "books.xml".
4. Click the "books.xml" file to open in browser by default.
books.xml
--------------------------------------
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="books.xsl"?>
<catalog>
<book id="bk9781118013847">
<title>Beginning Perl</title>
<author>Curtis Ovid Poe</author>
<genre>Computer Programming</genre>
<publisher>Wiley / Wrox</publisher>
<price>31.99</price>
<publish_date>August 2012</publish_date>
<isbn>978-1-4571-2094-7</isbn>
<description>Perl's basics and best practices for Beginners</description>
</book>
<book id="bk9780596527242">
<title>Mastering Perl</title>
<author>Brian d Foy</author>
<genre>Computer Programming</genre>
<publisher>O'Reilly Media</publisher>
<price>31.99</price>
<publish_date>July 2007</publish_date>
<isbn>978-0-596-52724-2</isbn>
<description>Focuses on real-life problems of debugging, maintenance, configuration</description>
</book>
<book id="bk9780470556801">
<title>Perl and Apache</title>
<author>Adam McDaniel</author>
<genre>Computer Programming</genre>
<publisher>Wiley / Visual</publisher>
<price>34.99</price>
<publish_date>January 2011</publish_date>
<isbn>978-1-4571-3092-2</isbn>
<description>A visual blueprint for developing dynamic Web content</description>
</book>
</catalog>
books.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>
<h2>Book Details</h2>
<table border="1" style="width:70%;">
<tr bgcolor="#9acd32">
<th>Id</th>
<th>Title</th>
<th>Author</th>
<th>Price ($)</th>
<th>Publish Date</th>
<th>Genre</th>
<th>Description</th>
</tr>
<xsl:for-each select="catalog/book">
<xsl:sort select="@id"/>
<tr>
<td><xsl:value-of select="@id"/></td>
<td align="center"><xsl:value-of select="title"/></td>
<td><xsl:value-of select="author"/></td>
<td align="right"><b><xsl:value-of select="price"/></b></td>
<td><xsl:value-of select="publish_date"/></td>
<td><xsl:value-of select="genre"/></td>
<td align="justify"><xsl:value-of select="description"/></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
Monday, September 2, 2013
Where do you get Perl binaries for MS Windows?
http://www.indigostar.com/
http://strawberryperl.com/
http://www.activestate.com/activeperl/downloads
http://strawberryperl.com/
http://www.activestate.com/activeperl/downloads
Thursday, July 18, 2013
Thursday, March 14, 2013
Full form of some Banks.
ICICI => Industrial Credit and Investment Corporation of India
HSBC => Hongkong and Shanghai Banking Corporation
HDFC => Housing Development Finance Corporation
IDBI => Industrial Development Bank of India
DENA => Development Enterprenure National Association
BNP => Banque Nationale de Paris
UTI => Unit Trust of India
UCO => United Commercial Bank
YES => Youth Enterprise Scheme
EXIM => Export Import Bank Of India
SIDBI => Small Industries Development Bank of India
NABARD => National Bank for Agriculture and Rural Development
Thursday, September 13, 2012
How do you create a pseudo drive or map a local folder to a pseudo drive in MS Windows?
Suppose, we want a folder (e.g. AutoDrive) to act as a pseudo drive. Now assume "Z:" to be used as Drive Letter, do either of the followings:
Click Start, choose Run and type:
SUBST Z: C:\AutoDrive
then click OK.
or
type "SUBST Z: C:\AutoDrive" at the command prompt without quotes.
Again, to remove the substituted "Z:" drive, follow either of the ways mentioned below:
click Start, choose Run and type:
SUBST Z: /d
or
type "SUBST Z: /d" at the command prompt without quotes.
Click Start, choose Run and type:
SUBST Z: C:\AutoDrive
then click OK.
or
type "SUBST Z: C:\AutoDrive" at the command prompt without quotes.
Again, to remove the substituted "Z:" drive, follow either of the ways mentioned below:
click Start, choose Run and type:
SUBST Z: /d
or
type "SUBST Z: /d" at the command prompt without quotes.
Tuesday, August 7, 2012
How could you beautify SQL script online?
You can take advantage of online syntax highlighter mentioned below :
http://www.tohtml.com/sql/
http://quickhighlighter.com/
http://sqlformat.appspot.com/
http://www.dpriver.com/pp/sqlformat.htm
http://www.tohtml.com/sql/
http://quickhighlighter.com/
http://sqlformat.appspot.com/
http://www.dpriver.com/pp/sqlformat.htm
How could you test your code online?
You can take advantage of the following Online Compilers :
http://ideone.com/
http://codepad.org/
http://compileonline.com/
http://ideone.com/
http://codepad.org/
http://compileonline.com/
Subscribe to:
Posts
(
Atom
)