473,326 Members | 2,108 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

WordML - an XML/XSLT challenge

I have the following table with merge rows as follows:

IDNUM IMAGE DESC CODENUM RATING NOTES
---------+-------+-------+------------+---------+---------
R1C1 R1C2 R1C3 R12345C4 R123C5 R12C6
R2C1 R234C2 R23C3
R3C1 R3C6
R4C1 R4C3 R4C5 R4C6
R5C1 R5C2 R5C3 R5C5 R56C6
R6C1 R6C2 R6C3 R6C4 R6C5
R7C1 R7C2 R7C3 R7C4 R7C5 R7C6

What I'd like to be able to do is to parse the above
table as it is in grid where the merged rows should have the same
values as describe same, e.g:
in Column C4, R1-5 are merged, therefore the value of R[1...5]C4
should be the same. Then, I'd like the final result should be the
following:

IDNUM IMAGE DESC CODENUM RATING NOTES
---------+-------+-------+------------+---------+---------
R1C1 R1C2 R1C3 R12345C4 R123C5 R12C6
R2C1 R234C2 R23C3 R12345C4 R123C5 R12C6
R3C1 R234C2 R23C3 R12345C4 R123C5 R3C6
R4C1 R234C2 R4C3 R12345C4 R4C5 R4C6
R5C1 R5C2 R5C3 R12345C4 R5C5 R56C6
R6C1 R6C2 R6C3 R6C4 R6C5 R56C6
R7C1 R7C2 R7C3 R7C4 R7C5 R7C6

If I have the 1st table in a Word Table, and would like to convert it to
an Access database table, what XLST schema should I use? How do I
put the rule to get the data and pump it into an Access table?

Thanks
Nov 12 '05 #1
1 1673
I solved this issue for xHTML. It was a hassle because Word's table model is not designed to make sense, but rather to look pretty.

If you want more information, then you can email me. My address here should have no capital letters in it, so remove them:
rI****@gAhTbEraSiPlAlMe.com

Cliff
Ruby Tuesdays wrote:
I have the following table with merge rows as follows:

IDNUM IMAGE DESC CODENUM RATING NOTES
---------+-------+-------+------------+---------+---------
R1C1 R1C2 R1C3 R12345C4 R123C5 R12C6
R2C1 R234C2 R23C3
R3C1 R3C6
R4C1 R4C3 R4C5 R4C6
R5C1 R5C2 R5C3 R5C5 R56C6
R6C1 R6C2 R6C3 R6C4 R6C5
R7C1 R7C2 R7C3 R7C4 R7C5 R7C6

What I'd like to be able to do is to parse the above
table as it is in grid where the merged rows should have the same
values as describe same, e.g:
in Column C4, R1-5 are merged, therefore the value of R[1...5]C4
should be the same. Then, I'd like the final result should be the
following:

IDNUM IMAGE DESC CODENUM RATING NOTES
---------+-------+-------+------------+---------+---------
R1C1 R1C2 R1C3 R12345C4 R123C5 R12C6
R2C1 R234C2 R23C3 R12345C4 R123C5 R12C6
R3C1 R234C2 R23C3 R12345C4 R123C5 R3C6
R4C1 R234C2 R4C3 R12345C4 R4C5 R4C6
R5C1 R5C2 R5C3 R12345C4 R5C5 R56C6
R6C1 R6C2 R6C3 R6C4 R6C5 R56C6
R7C1 R7C2 R7C3 R7C4 R7C5 R7C6

If I have the 1st table in a Word Table, and would like to convert it to
an Access database table, what XLST schema should I use? How do I
put the rule to get the data and pump it into an Access table?

Thanks

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tom Frey | last post by:
Hi, is there any solution available for transforming WordML XML files to PDF on server requests. Here is basically what I'm looking for: We have like 15 different types of contracts that have...
0
by: Sascha Kerschhofer | last post by:
Hi, has anyone a XSLT-File that can convert an xsl:fo file to WordML. Wouldn't it be nice to have such a thing? Sascha Kerschhofer
5
by: Clifford W. Racz | last post by:
Has anyone solved the issue of translating lists in Word 2003 (WordML) into xHTML? I have been trying to get the nested table code for my XSLT to work for a while now, with no way to get the...
0
by: Logician | last post by:
Can anyone point me in the right direction for XML creation from WordML, after using a JPEG/OCR? Problem ======= 1. The WordML has font tags, and I need just data tags for reading by ..NET ...
0
by: Altsoft Xml2PDF | last post by:
Xml2PDF formatting engine version 2.3 May 25, 2004 Altsoft N.V. Altsoft N.V. is proud to announce the release of version 2.3 of its Xml2PDF formatting engine. The update includes: -...
3
by: utterberg | last post by:
If I have an xml that looks something like this: <section> <item> <label>label one</label> <data>123</label> </item> <item> <label>label two</label> <data>456</label>
7
by: One Handed Man \( OHM - Terry Burns \) | last post by:
I've been battling with this stupid problem for hours now. WebApp: Trying to do a simple transformation using XSLT to a Web Page, but it just failes without an error message ( In other words,...
0
by: JD | last post by:
Hello: I am trying to put together a solution that would programmatically insert XML data into a WordML document. I am trying to do this through a web page when a user clicks on a link. For...
1
by: AndreasAndersson | last post by:
Hi! I'm trying to design an XSLT in order to transform an XML document into another XML document. The source XML looks something like this: <?xml version="1.0" encoding="UTF-8"?> <Orders>...
1
by: Pedro Rosas Silva | last post by:
Hi everyone, Is anybody aware of a way how to insert an image in a WordML document programmatically, through C#? I have a C# application that loads into memory a WordML document...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.