![]() |
![]() | ![]() | ![]() | Altova Mailing List Archives>Archive Index >microsoft.public.xsl Archive Home >Recent entries >Thread Prev - XSLT PROCESSING >Thread Next - RE: XSLT PROCESSING RE: XSLT PROCESSINGTo: NULL Date: 10/1/2004 10:15:00 AM Please try this XSL -
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
<xsl:output method="xml" encoding="UTF-8" indent="yes"/>
<xsl:variable name="month-map">
<months>
<month>
<string>Jan</string>
<number>1</number>
</month>
<month>
<string>Feb</string>
<number>2</number>
</month>
<month>
<string>Mar</string>
<number>3</number>
</month>
<month>
<string>Apr</string>
<number>4</number>
</month>
<month>
<string>May</string>
<number>5</number>
</month>
<month>
<string>Jun</string>
<number>6</number>
</month>
<month>
<string>Jul</string>
<number>7</number>
</month>
<month>
<string>Aug</string>
<number>8</number>
</month>
<month>
<string>Sep</string>
<number>9</number>
</month>
<month>
<string>Oct</string>
<number>10</number>
</month>
<month>
<string>Nov</string>
<number>11</number>
</month>
<month>
<string>Dec</string>
<number>12</number>
</month>
</months>
</xsl:variable>
<xsl:template match="@* | node()">
<xsl:copy>
<xsl:apply-templates select="@*"/>
<xsl:apply-templates select="node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="field2">
<xsl:variable name="mnth" select="substring-before(., '.')"/>
<xsl:variable name="date" select="substring-before(substring-after(., '
'), ' ')"/>
<xsl:variable name="year" select="substring-after(substring-after(., '
'), ' ')"/>
<field2>
<xsl:value-of select="msxsl:node-set($month-map)/months/month[string
= $mnth]/number"/>/<xsl:value-of select="$date"/>/<xsl:value-of
select="$year"/>
</field2>
</xsl:template>
</xsl:stylesheet>
Regards,
Mukul
"JZYCN2" wrote:
> Hi
> I have record sets in XML like following
> <field1>j3456</field1><field2>Aug. 23 2004</field2>....
> <field1>jhgert</field1><field2>Aug. 21 2004</field2>...
> <field1>j12dfg</field1><field2>Aug. 12 2004</field2>..
> .....
>
> Now I want to display field2 different way lile format in 8/23/2004 way and
> other fields I want to display as it is. Can anyone advise how to do it.
>
> Thanks a bunch in advance
| ![]() | ![]() | ![]() |
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | |||||
|
