ansaurus

Question

How to extract this date format in xslt

Answer 1

A:

Doesn't have xslt a substring command?

codymanix 2010-08-18 13:23:53

I tried but how to use substring here?

Wondering 2010-08-18 13:24:50

The elements in the string have always a fixed position. What exactly is your problem?

codymanix 2010-08-18 13:41:46

it is working, but is there any better way of doing that?

Wondering 2010-08-18 13:48:02

Define "better". You mean less dependent on the specifics of the format? If so, describe what range of formats you want to handle.

LarsH 2010-08-18 14:26:01

I just wanted it to be generic, and not dependent on substring and index.

Wondering 2010-08-18 15:47:11

If you're looking at conversions from strings to dates/times generic is almost impossible because time and date formats are so variable. Given the example, substring should work because the positions are going to be consistent, hmm or possibly not - is it 1 Aug or 01 Aug and is it 1:02:03 or 01:02:03 ??

Murph 2010-08-18 16:37:39

Answer 2

A:

This is a good library to use: EXSLT.

dnagirl 2010-08-18 13:25:13

Answer 3

A:

I found this in a discussion - http://geekswithblogs.net/workdog/archive/2007/02/08/105858.aspx which might help you.

shankys 2010-08-18 13:28:51

Answer 4

A:

This is a simple modification from my answer in your previous question so all the same there mentioned restrictions apply here also.

<xsl:variable name="time" select="substring(Date, string-length(substring-before(Date, ':') - 1, 5)"/>

jasso 2010-08-18 18:07:42

Answer 5

A:

If you can use XPath 2.0, you could use tokenize():

XML

<?xml version="1.0" encoding="UTF-8"?>
<Date>Mon, 11 Aug 2009 13:15:10 GMT</Date>

XSLT

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt;
   <xsl:output method="text"/>

   <xsl:template match="/Date">
     <xsl:value-of select="tokenize(tokenize(.,' ')[5],':')[position() &lt; 3]"/>
   </xsl:template>

</xsl:stylesheet>

OUTPUT

13 15

DevNull 2010-08-20 09:51:59

ansaurus

tags:

views:

answers:

How to extract this date format in xslt

related questions