XSLT 1.0 Split one Field into Two

stlyz3 · February 23rd, 2009, 01:07 AM

Hi all,

I have a situation where I need to take a XML response and split the values given into two fields. Im using XSLT version 1.0 and my XML looks like this:

<ns:response>
<thisisresponse>abcdef|123456</thisisresponse>
</ns:response>

I would like this to look something like this after XSL transformation:

<field1>abcdef</field1>
<field2>123456</field2>

The separator is the "|"

Is there are simple way to do this?

mrame · February 23rd, 2009, 02:08 AM

Try this:

Code:

 
<xsl:template match="ns:response">
<field1><xsl:value-of select="substring-before(., '|')"/></field1>
<field2><xsl:value-of select="substring-after(., '|')"/></field2>
</xsl:template>

JohnBampton · February 23rd, 2009, 02:10 AM

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:ns="http://www.foo.org">
    <xsl:template match="/">
        <field1>
            <xsl:value-of select="substring-before(ns:response/thisisresponse,'|') "/>
        </field1>
        <field2>
            <xsl:value-of select="substring-after(ns:response/thisisresponse,'|') "/>
        </field2>
    </xsl:template>
</xsl:stylesheet>

Cheers, John Bampton

stlyz3 · February 23rd, 2009, 03:42 PM

Thanks a lot for your help. It worked perfectly!