Hey All, I got the solution to my problem. Here is the xsl: <?xml version='1.0'?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" exclude-result-prefixes="ss" version="2.0"> <xsl:output i...

Hello Experts, I have got a following input file : <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="14" ss:ExpandedRowCount="11" x:FullColumns="1" x:FullRows="1" ss:DefaultRowHeight="15"> <Row> <Cell><Data ss:Type="String&qu...

Hey Krishna,

Do have a look at the link below which suggests how to link the xml and stylesheet and then view the output.

http://www.w3schools.com/xsl/xsl_transformation.asp

Cheers and Good Luck!
Sandeep

Dear All, I finally got the solution to my problem, although its not full proof yet it gives us a good approach. I have created a function using <xsl:function> which takes 2 parameters namely the input string and the key for which value needs to be extracted. So, suppose if we have a string as key1,...

Hi George, I really appreciate the time and effort you are putting into this. Nothing can I really say will do justice for your help. However, the system I am working on has got limitations and it can NOT process 2 XSL transformations, so the solution of 2 XSLs does not fulfill the requirement. Also...

Hey George, Many Thanks for your help. :D The solution you have provided is very close to what I wanted, however there is a slight change in the test.xml as below: <root> <test1>$variable1</test1> <some-node> <child-node>note</child-node> </some-node> <test2>$variable2</test2> <some-node> <child-nod...

Hi George,

Thanks for your help.

The output source document is not only derived from given source document but also consists of some other predefined nodes.
The delimited string from the source document will be parsed to insert/ update the values of these predefined nodes.

Cheers, Sandeep

Hello All, I want to convert the following xml <root> <name>test1,value1|test2,value2|test3,value3|test4,value4|</name> </root> to <root> <test1>value1</test1> <some-node> <child-node>note</child-node> </some-node> <test2>value2</test2> <some-node> <child-node>note</child-node> ... more child nodes ...

Hi Sorin,

Many Thanks for your reply.

I had already set the attribute version to 2.0 in stylesheet, however I was validating it with Saxon6.5.5. I have changed this processor to Saxon-B 9.1.0.3 and it worked.

Thanks again for your help, much appreciated.

Cheers, Sandeep

Hi, I am using few XSL functions like 'index-of' but the Oxygen editor thrown an error of 'Unknown System Function - index-of' error. My code snippet is as shown below: <xsl:element name="{$temp}"> <xsl:value-of select="index-of($txt, '|')"/> </xsl:element> I have changed the Sch...