How do I remove and re-arrange data DD-MM-YYYY to YYYYMMDD for example given 03-09-2011 how do I manipulate it to 20110903

The code is tedious but simple, it just involves a call on concat() and several calls on substring()

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

is it the same if I need to change from M/D/YYYY H:MM:SS to YYYY-MM-DD?

or should I first convert to MM/DD/YYYY HH:MM:SS?

<xsl:variable name="date" select="xs:date(concat(
substring($d,6,4),'-',
substring($d,1,2),'-',
substring($d,3,2)
))"/>
<xsl:value-of select="format-date($date,'[Y1,4]-[M2]-[D2]')"/>

with substring, unless I do not understand something it seems not possible to tell a regular start and length as both M and D might actually be 2 characters.

thanks for any help

In XPath 2.0 this is best done using regular expressions.

If you're stuck with 1.0, you can do it with a tedious sequence of calls on substring-before() and substring-after().

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

I would be very glad to do this with regex.

what I tried to do is to put in a variable only the date using (\d*)/(\d*)/(\d\d\d\d)
but I believe my regex is probably wrong, cause I get no result.

could you please help me?

thank you very much
Pietro

First, a new question should go on a new thread. Don't hijack old threads from years ago.

Secondly, if your code is wrong then I can help you get it right, but only if you show me your code.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference