XSLT parsing

[David Walker]

Hi,

I have an XML file created by a third party in which an element with a
simple content model has a text value consisting of 2 parts separated by a
colon, like this

<link>machineort</link>

Is XSLT capable of parsing the value of a <link> element, to separately
extract the portions before and after the colon?

Regards
David Walker

 

[Martin Honnen]

David Walker wrote:

I have an XML file created by a third party in which an element with a
simple content model has a text value consisting of 2 parts separated by a
colon, like this

<link>machineort</link>

Is XSLT capable of parsing the value of a <link> element, to separately
extract the portions before and after the colon?

Yes, XPath 1.0 is used in XSLT 1.0 and has functions to break up strings
e.g.
substring-before(//link, ':')
substring-after(//link, ':')

 

[Andrew Urquhart]

I have an XML file created by a third party in which an element with a
simple content model has a text value consisting of 2 parts separated
by a colon, like this

<link>machineort</link>

Is XSLT capable of parsing the value of a <link> element, to
separately extract the portions before and after the colon?

Yes, e.g.:

<xsl:template match="link">
<xsl:choose>
<xsl:when test="contains(., ':')">
<xsl:text>Before = &quot;</xsl:text>
<xsl:value-of select="substring-before(., ':')"/>
<xsl:text>&quot;, after = &quot;</xsl:text>
<xsl:value-of select="substring-after(., ':')"/>
<xsl:text>&quot;</xsl:text>
</xsl:when>
<xsltherwise>
<xsl:value-of select="."/>
</xsltherwise>
</xsl:choose>
</xsl:template>

 

[Kimmo J?rvikangas]

Hi,

I have an XML file created by a third party in which an element with a
simple content model has a text value consisting of 2 parts separated by a
colon, like this

<link>machineort</link>

Is XSLT capable of parsing the value of a <link> element, to separately
extract the portions before and after the colon?

Regards
David Walker

David,

I suppose there are many ways of achieving that. Here is just one example:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<xsl:apply-templates select="link"/>
</xsl:template>
<xsl:template match="link">
<xsl:variable name="machine" select="substring-before( . , ':' ) "/>
<xsl:variable name="port" select="substring-after( . , ':' ) "/>
<xsl:element name="link">
<xsl:element name="machine">
<xsl:value-of select="$machine"/>
</xsl:element>
<xsl:element name="port">
<xsl:value-of select="$port"/>
</xsl:element>
</xsl:element>
</xsl:template>
</xsl:stylesheet>

This will transform Your example

<?xml version="1.0" encoding="UTF-8"?>
<link>machineort</link>

To the following:

<?xml version="1.0" encoding="UTF-8"?>
<link>
<machine>machine</machine>
<port>port</port>
</link>

Is this something like You were after?

Rgds,

<kimmo/>