Hello,

I need to transform the following string: "2009-01-30T20:00:00Z" into "20090130T200000Z".
Also need to create another string by adding "3" to the value right after "T" so "20090130T200000Z" becomes "20090130T230000Z"

The initial string is a variable so I need some sort of a template that would work for other strings formatted like the example given. Addition is always the same "+3" to the value of two digits after "T"

Thanks!

Try this:
<xsl:template match="/">
        <xsl:variable name="a1">2009-01-30T20:00:00Z</xsl:variable>
        <xsl:variable name="a2"><xsl:value-of select="tokenize($a1, 'T')[1]"/></xsl:variable>
        <xsl:variable name="a3"><xsl:value-of select="tokenize($a1, 'T')[2]"/></xsl:variable>
        <xsl:variable name="a4"><xsl:value-of select="tokenize($a3, ':')[1]"/></xsl:variable>
        <xsl:variable name="a5"><xsl:value-of select="$a4 + 3"/></xsl:variable>
        <xsl:value-of select="replace(concat($a2, 'T', replace($a3, $a4, $a5)), '-|:', '')"></xsl:value-of>
    </xsl:template>

There can be better solution than this.

------
Rummy

For the first part use the translate function, translate($x, '-:', ''). to remove all - and : replace with nothing. For the second part you could use substring and substring-before to extract the digits you need. What happens if the time is after 21? You will end up with a time of 25 or more, is that acceptable?

--

Joe (Microsoft MVP - XML)

Thanks guys, I went the translate way to get this done.
Question about time after 21 is totally valid BUT I'm lucky in the way that my data set never exceed 20, and if at some point it does, i'll just put a when/otherwise and add 2 or 1 instead of 3, it will make sense for my purpose.

Once again thanks for replies.