Help needed to read the XML using XSLT
Hello Experts,
XML:
<si>
<t>Hello World</t>
</si>
To read the "Hello World" in aforementioned XML I use the following XSL,
<xsl:if test="$v_index">
<xsl:value-of select="$V_SHARED_STRING/sst/si[$v_index + 1]/t"/>
</xsl:if>
This is working perfectly..
In some cases, the XML would be like the below,
<si>
<r>
<t xml:space="preserve">Hello </t>
</r>
<r>
<rPr>
<u/>
<sz val="11"/>
<color theme="1"/>
<rFont val="Calibri"/>
<scheme val="minor"/>
</rPr>
<t>World</t>
</r>
<r>
<rPr>
<sz val="11"/>
<color theme="1"/>
<rFont val="Calibri"/>
<family val="2"/>
<scheme val="minor"/>
</rPr>
<t xml:space="preserve"> 123</t>
</r>
</si>
From the aforementioned I would like to read the string "Hello World 123".
CASE 1: Reading the string from node <t> --> Solved
CASE 2: Reading the string from node <r> concatenated with the values present in subnodes <t>
Could you help me to do CASE 1 and CASE 2 together?
Thanks a lot for help
Regards,
Benu
|