How to set split value in XSL 1.0

Question

I need to set split values in different parameters.My response like below.

  `<Response >
     <Result>100002 0 Testing 1500.00 YES</Result>
  </Response>`

What i need is to get above split value in different result like below .[please note i have hard coded "select="100002" " values]

          ` <xsl:element name="ns1:Response">
              <xsl:value-of select="100002">
           </xsl:element>`

     `<xsl:element name="ns1:amount">
              <xsl:value-of select="0 ">
           </xsl:element>`

    `<xsl:element name="ns1:name">
              <xsl:value-of select="Testing  ">
           </xsl:element>`

   `<xsl:element name="ns1:Amount">
              <xsl:value-of select="1500.00">
           </xsl:element>`

 `<xsl:element name="ns1:Other">
              <xsl:value-of select="Yes">
           </xsl:element>`

score 0 · Answer 1 · answered Nov 17 '17 at 09:33

0

There are plenty topics to a split function already. E.g.: Split implementation

This should help you out. WithRefering to that you should just need a result template looking like this:

<xsl:template match="result">
    <xsl:call-template name="splitfunction">
        <xsl:with-param name="string" select="."/>
        <xsl:with-param name="seperator" select=" "/>
    </xsl:call:template>
</xsl:template>

answered Nov 17 '17 at 09:33

Christian Mosz

543
2
12

Thanks.have to looking into that – Kasun Nov 17 '17 at 09:35
An alternative would be to use a loop over the result of [the function tokenize][2]. Depends what you prefer. [2]: https://www.w3.org/TR/xpath-functions/#func-tokenize – Christian Mosz Nov 17 '17 at 09:37

Rupesh_Kr · Accepted Answer · 2017-11-21T09:58:13.937

0

You can use

<xsl:template match="Result">
        <xsl:call-template name="abc">
            <xsl:with-param name="data" select="."></xsl:with-param>
        </xsl:call-template>
    </xsl:template>

        <xsl:template name="abc">
    <xsl:param name="data"/>
    <xsl:element name="ns1:Response">
        <xsl:value-of select="substring-before($data, ' ')"/>
    </xsl:element>

    <xsl:element name="ns1:amount">
        <xsl:value-of select="substring-before(substring-after($data, ' '), ' ')"/>
    </xsl:element>

    <xsl:element name="ns1:name">
        <xsl:value-of select="substring-before(substring-after(substring-after($data, ' '), ' '), ' ')"/>
    </xsl:element>

    <xsl:element name="ns1:Amount">
        <xsl:value-of select="substring-before(substring-after(substring-after(substring-after($data, ' '), ' '), ' '), ' ')"/>
    </xsl:element>

    <xsl:element name="ns1:Other">
        <xsl:value-of select="substring-after(substring-after(substring-after(substring-after($data, ' '), ' '), ' '), ' ')"/>
    </xsl:element>
</xsl:template>

edited Nov 21 '17 at 09:58

answered Nov 17 '17 at 09:42

Rupesh_Kr

3,395
2
17
32

hii @Rupesh my issue is these results will change every time as below. ` 10000209 0 Resting 100.00 NO ` ` 100002 8 Reduce 1900.00 NO ` ` 99999 7 Root 1200.00 MayBe ` – Kasun Nov 17 '17 at 11:08
@Kasun Updated as per your requirement – Rupesh_Kr Nov 21 '17 at 09:58
hi @Rupesh is there any possibility separate this kind of results. 0~3~889499~21/12/2017 i need separate these results like as below – Kasun Dec 21 '17 at 12:09
@Kasun, Just change `' '` with `'~'`, above condition is written for `space` so change it to `~`. – Rupesh_Kr Dec 22 '17 at 04:48
@Kasun, if this answer solved your query, than accept answer. so this question can be closed. – Rupesh_Kr Dec 22 '17 at 04:49
have a problem again '; ; @@ 23333333 -89 WrongData $$ ' This not working using above method any idea thanks – Kasun Jan 12 '18 at 17:16
have you added namespace in xslt? – Rupesh_Kr Jan 12 '18 at 17:51

How to set split value in XSL 1.0

2 Answers2