How to convert this xml file into Target xml file using XSLT

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
<span style="color:#333333; font-family:arial,helvetica,sans-serif; font-size:13px Hi,<br/>
<br/>
I am not able to put the subquestions inside the corresponding questions. Please any one suggest me how can i achieve this. This is very urgent requirement for me. Please help.....

<span style="color:#333333; font-family:arial,helvetica,sans-serif; font-size:13px Actual requirement is i need to convert a word document into specific xml format. So i am saving the word doc as word-xml2003 and trying to convert that to target xml
format using xslt. Since those files are big, i made a sample format which I have posted. <br/>
<br/>
We can differentiate the question and sub question by the Paranthesis. Data starting with paranthesis is a subquestion. <br/>
<br/>
I have to use xslt 1.0<span style="color:#333333; font-family:arial,helvetica,sans-serif; font-size:13px <br/>
<br/>
<br/>
Here is the Input XML File:

<span style="color:#333333; font-family:arial,helvetica,sans-serif; font-size:13px
<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <?<span style="color:#A31515; xml <span style="color:Red; version<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 1.0<span style="color:Black; " <span style="color:Red; encoding<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; UTF-8<span style="color:Black; "<span style="color:Blue; ?>
<span style="color:Blue; <<span style="color:#A31515; tables<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; table<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
This is the title of the table.
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
1. Question
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
2. Question
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
(Subquestion1)
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
(Subquestion2)
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
3. Question
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
(Subquestion1)
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
4. Question
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; table<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; table<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
This is the title of the table.
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
1. Question
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
(Subquestion)
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
(Subquestion)
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
2. Question
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
3. Question
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
(Subquestion)
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; data<span style="color:Blue; >
4. Question
<span style="color:Blue; </<span style="color:#A31515; data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tc<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; table<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tables<span style="color:Blue; >
[/code]
<br/>
<span style="color:#333333; font-family:arial,helvetica,sans-serif; font-size:13px Here is the required Output XML: <br/>
<div style="
<div style="font:normal normal normal 11px/normal verdana,geneva,lucida,lucida grande,arial,helvetica,sans-serif; margin-bottom:2px
Code:

<div style="font:normal normal normal 11px/normal verdana,geneva,lucida,lucida grande,arial,helvetica,sans-serif; margin-bottom:2px

<div style="font:normal normal normal 11px/normal verdana,geneva,lucida,lucida grande,arial,helvetica,sans-serif; margin-bottom:2px
<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <?<span style="color:#A31515; xml <span style="color:Red; version<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 1.0<span style="color:Black; " <span style="color:Red; encoding<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; UTF-8<span style="color:Black; "<span style="color:Blue; ?>
<span style="color:Blue; <<span style="color:#A31515; Sections<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; section <span style="color:Red; title<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; This is the title of the table.<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Questions<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Question<span style="color:Blue; >
1.Question
<span style="color:Blue; </<span style="color:#A31515; Question<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Question<span style="color:Blue; >
2.Question
<span style="color:Blue; <<span style="color:#A31515; SubQuestion<span style="color:Blue; >
Subquestion1
<span style="color:Blue; </<span style="color:#A31515; SubQuestion<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; SubQuestion<span style="color:Blue; >
Subquestion2
<span style="color:Blue; </<span style="color:#A31515; SubQuestion<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Question<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Question<span style="color:Blue; >
3.Question
<span style="color:Blue; <<span style="color:#A31515; SubQuestion<span style="color:Blue; >
Subquestion1
<span style="color:Blue; </<span style="color:#A31515; SubQuestion<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Question<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Question<span style="color:Blue; >
4.Question
<span style="color:Blue; </<span style="color:#A31515; Question<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Questions<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; section<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; section <span style="color:Red; title<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; This is the title of the table.<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Questions<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Question<span style="color:Blue; >
1.Question
<span style="color:Blue; <<span style="color:#A31515; SubQuestion<span style="color:Blue; >
Subquestion1
<span style="color:Blue; </<span style="color:#A31515; SubQuestion<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; SubQuestion<span style="color:Blue; >
Subquestion2
<span style="color:Blue; </<span style="color:#A31515; SubQuestion<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Question<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Question<span style="color:Blue; >
2.Question
<span style="color:Blue; </<span style="color:#A31515; Question<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Question<span style="color:Blue; >
3.Question
<span style="color:Blue; <<span style="color:#A31515; SubQuestion<span style="color:Blue; >
Subquestion
<span style="color:Blue; </<span style="color:#A31515; SubQuestion<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Question<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Question<span style="color:Blue; >
4.Question
<span style="color:Blue; </<span style="color:#A31515; Question<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Questions<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; section<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Sections<span style="color:Blue; >
[/code]
<br/>
<br/>


<hr class="sig Sudheer Kokirala, www.techvedika.com

View the full article
 
Back
Top