Converting SSI variables to XML

Play the video

Subject: Converting SSI variables to XML
From: "tom tom" <tomxsllist@xxxxxxxxxxx>
Date: Mon, 11 Sep 2006 16:29:29 +0100

Hi all, I wish to turn the following CDATA input:

<xml>

<![CDATA[

<!--#set var="t.news.1.title" value="This is the title"-->
<!--#set var="t.news.1.image_small" value="smallimage"-->
<!--#set var="t.news.1.image_large" value="largeimage"-->

<!--#set var="t.news.2.title" value=""-->
<!--#set var="t.news.2.image_small" value=""-->
<!--#set var="t.news.2.image_large" value=""-->

<!--#set var="t.news.3.title" value=""-->
<!--#set var="t.news.3.image_small" value=""-->
<!--#set var="t.news.3.image_large" value=""-->


]]>
   </xml>

Into XML as follows using XSLT 2:

<ts>
 <group num="1">
  <var name="t.news.1.title" value="This is the title"/>
  <var name="t.news.1.image_small" value="smallimage"/>
  <var name="t.news.1.image_large" value="largeimage"/>
 </group>
 <group num="2">
  etc.....
 </group>
</ts>

I have used the analyze-string function to do a regex match on the HTML comments, it then extracts the values of 'var' and 'value' to create:

<ts>

  <var name="t.news.1.title" value="This is the title"/>
  <var name="t.news.1.image_small" value="smallimage"/>
  <var name="t.news.1.image_large" value="largeimage"/>

etc.....

</ts>

To add the grouping I will need to do another pass over this data however I am finding it complex to extract the numerical data from the string at @name and it seems unnecessary complex. I have also tried nesting xsl:analyze-string elements to create a group first then the individual variables. Can anyone recommend the correct way to do this?

Thanks in advance

Tom

_________________________________________________________________ Download the new Windows Live Toolbar, including Desktop search! http://toolbar.live.com/?mkt=en-gb

Current Thread
Converting SSI variables to XML tom tom - 11 Sep 2006 15:30:33 -0000 <= David Carlisle - 11 Sep 2006 15:39:52 -0000 Abel Braaksma - 11 Sep 2006 15:50:00 -0000

<- Previous	Index	Next ->
Re: Keyword xsl:key may not b, Bob Portnell	Thread	Re: Converting SSI variables , David Carlisle
Re: Keyword xsl:key may not b, David Carlisle	Date	Re: Keyword xsl:key may not b, Mukul Gandhi
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >