Oxygen XML Forum

Hi,

am new to XSLT, i have the MQ message that message am able to read from queue, that message in the below format

<payload>aaa,111,ap,india</payload>

i need a help to convert this MQ message into the XML message using the XSLT

means expected output should be like this

<?xml version="1.0" encoding="UTF-8"?>
<empdetails><empname>abc</empname><empid>111</empid><empstate>ap</empstate><empcountry>india<empcountry></empdetails>


am totally new to this XSLT, it would be gr8 if some one provide me the XSLT for this

Thanks in advance

If you're using XSLT 2.0, this can easily be done with the tokenize function. Otherwise you'll have to use functions substring-before() and substring-after()

eg:
<empname><xsl:value-of select="substring-before(payload,',')"/></empname>
<empid><xsl:value-of select="substring-before(substring-after(payload ,',') ,',')"/></empid>

and so forth. You can use temporary variables to lessen the confusion.

http://www.w3schools.com/xpath/xpath_functions.asp

jkmyoung wrote:If you're using XSLT 2.0, this can easily be done with the tokenize function. Otherwise you'll have to use functions substring-before() and substring-after()

eg:
<empname><xsl:value-of select="substring-before(payload,',')"/></empname>
<empid><xsl:value-of select="substring-before(substring-after(payload ,',') ,',')"/></empid>

and so forth. You can use temporary variables to lessen the confusion.

http://www.w3schools.com/xpath/xpath_functions.asp

Thanks for the reply,but the above logic will work for the only 3 fileds, but i have the 20 fileds

if the above logic works for the 20 fileds, could you please let me know how it's work's

for third filed i have used like this

<empcountry><xsl:value-of select="substring-before(substring-after(datastream/payload,','),',')"/></empcountry>

but after this am not getting how to do for the next field

please help me

Well if you did it this way, the 3rd field would be
substring-before(substring-after(substring-after(payload ,','),',') ,',')
which quickly gets ridiculous.

I suggest a recursive approach instead.
Global variable:
<xsl:variable name="numFields" select="20"/>

Inside template:
<xsl:call-template name="parse">
<xsl:with-param name="str" select="payload">
<xsl:with-param name="index" select="1">
</xsl:call-template>

After template:
<xsl:template name="parse">
<xsl:param name="str">
<xsl:param name="index">
<xsl:variable name="value">
<xsl:value-of select="substring-before($str, ',')"/>
<xsl:if test="$index = $numFields"><xsl:value-of select="$str"/></xsl:if>
</xsl:variable>
<xsl:variable name="field">
<xsl:choose>
<xsl:when test="$index = 1">empname</xsl:when>
<xsl:when test="$index = 2">empid</xsl:when>
<xsl:when test="$index = 3">empstate</xsl:when>
<xsl:when test="$index = 4">empcountry</xsl:when>
....
</xsl:choose>
</xsl:variable>
<xsl:element name="{$field}"><xsl:value-of select="$value"/></xsl:element>
<xsl:if test="$index < $numFields>
<xsl:call-template name="parse">
<xsl:with-param name="str" select="substring-after($str, ',')">
<xsl:with-param name="index" select="$index + 1">
</xsl:call-template>
</xsl:if>
</xsl:template>