Member Avatar for Johan_1974

Hello is it possible to use xslt to go from

<XML>
  <TAG1>tag1value1;tag1value2</TAG1> 
  <TAG2>tag2value1;tag2value2</TAG2> 
</XML>

To this

<XML>
    <LINE>
    <TAG1>tag1value1</TAG1> 
    <TAG2>tag2value1</TAG2> 
     </LINE>
     <LINE>
    <TAG1>tag1value2</TAG1> 
    <TAG2>tag2value2</TAG2> 
     </LINE>
</XML>

Any help would be most appreciated.

Johan

  • 2 Contributors
  • 1 Reply
  • 92 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by kevin patel
Member Avatar for kevin patel

u can use this substring-before($string,';')
and substring($string,';')
eg:
<xsl:variable name="full" select="k/time" ></xsl:variable>
<xsl:variable name="date" select="substring-before($full,'T)"></xsl:variable>
<xsl:variable name="time" select="substring-after($full,'T')"></xsl:variable>

where $full = '2012-09-21T10:15:00'
and we get $date ='2012-09-21'
$time = '10:15:00'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.