How to create a table using xslt

Question

I've the dictionary in inside the tag and I wanted to create the table from it. Here is the xml file I've

<parent>
  <thread thread_id="5e778ef9a28f9a51fec330b4">
    {'relative_to_thread_interactors': 1.0, 'relative_to_self_threads': 1.0}
  </thread>
  <thread thread_id="5e778ef9a28f2b51fec330A3">
    {'relative_to_thread_interactors': 2.0, 'relative_to_self_threads': 1.0}
  </thread> 
</parent>

And here is my xslt


<xsl:for-each select="parent/thread">
  <tr>
    <td><xsl:value-of select="@thread_id"/></td>
    <td><xsl:value-of select="thread"/></td>
  </tr>
</xsl:for-each>

Now my question is how to create a table from the dictionary value?

| thread_id                | relative_to_thread_interactors |
|--------------------------|--------------------------------|
| 5e778ef9a28f2b51fec330A3 | 2.0                            |

Please state which version of XSLT your processor supports.

michael.hor257k
– michael.hor257k

2020-03-25 19:02:14 +00:00
Commented Mar 25, 2020 at 19:02 — michael.hor257k
– michael.hor257k, Commented Mar 25, 2020 at 19:02

michael.hor257k · Accepted Answer · 2020-03-25 19:13:05Z

2

In XSLT 1.0 you can do:

<xsl:template match="/parent">
    <table>
        <tr>
            <th>thread_id</th>
            <th>relative_to_thread_interactors</th>
        </tr>
        <xsl:for-each select="thread">
            <tr>
                <td>
                    <xsl:value-of select="@thread_id"/>
                </td>
                <td>
                    <xsl:value-of select='substring-before(substring-after(., "&apos;relative_to_thread_interactors&apos;: "), ",")'/>
                </td>
            </tr>
        </xsl:for-each>
    </table>
</xsl:template>

In XSLT 2.0 it could be more elegant by using regex.

answered Mar 25, 2020 at 19:13

michael.hor257k

118k6 gold badges36 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Cloud Learner Over a year ago

Hey that works. Found this substring-before(haystack ,needle ) in mozilla doc 😂

Cloud Learner Over a year ago

Hi Michael. Is it possible to print all the keys in that dictionary. ?

Collectives™ on Stack Overflow

How to create a table using xslt

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related