xsl-list
[Top] [All Lists]

RE: parsing string or numbers after x characters

2004-07-13 01:51:14

My problem is that I receive for example a date in a 
concatenated format:

Ex: 20041207

And I have to retrieve it in a readable format through my xslt-fo 
transformation.

Ex. 12 July 2004

Are you sure that date is 12 July and not 7 December? Probably a stupid
question, it's just that I've never seen dates written as YYYYDDMM before.

Anyway: two solutions. I'll assume the value is in $d.

XSLT 2.0:

format-date(
  xs:date(
    concat(
      substring($d,1,4),
      '-',
      substring($d,7,2),
      '-',
      substring($d,5,2))),
    '[D01] [MNn] [Y0001]')

XSLT 1.0:

   concat(
      substring($d,1,4),
      '-',
      $months/m[number(substring($d,7,2))],
      '-',
      substring($d,5,2))> 

where $months is

<xsl:variable name="months">
<m>January</m>
<m>February</m>

etc.

Michael Kay


I tried using the substring attribute for that, but I don't have any 
reference character to look at so it doesn't work. Is there a 
function 
which parses strings or numbers after a certain amount of characters 
directly?

Thanks in advance for those which will response.


Julien

--+------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--+--





<Prev in Thread] Current Thread [Next in Thread>