Writing XML Table in a text file

anand18101984 · #1 June 25th, 2009, 05:44 PM

I have an XML file with a table in the below format,

Expand|Select|Wrap|Line Numbers

 <TABLE>

            <TR>

              <TH>EVENT</TH>

              <TH>SUMMARY</TH>

            </TR>

            <TR>

              <TD>US approval of Xience V</TD>

              <TD>Xience V is the first drug-eluting stent to demonstrate superiority over another DES in the primary endpoint of in- segment late loss, in the randomized controlled head-to-head SPIRIT III trial, and received FDA approval in July 2008. Morgan Stanley analysts expect US sales of $700m as early as 2009. Credit Suisse forecast sales of more than $1bn in 2009. Xience V could boost Abbott's annual revenue growth by 1% and EPS growth by 5%.</TD>

            </TR>

</TABLE>

I need to write this XML table in a text file in the below format,
EVENT SUMMARY \
Acquisition of Guidant's Abbott expected to find respite \
vascular business from a volatile pharmaceutical \
market by acquiring Guidant's \
vascular business for $3.8 \
billion in a deal closed in \
April 2006. Morgan Stanley \
analysts suggest the deal will \
secure 10% earnings growth for \
Abbott for the next four years. \

Points to be noted:
Number of characters in a line should not exceed 67.
columns should be equally splitted and the values in the cell should be wrapped to fit into the width of the column.
each line should have "\" at the end.

I have attached the output file with this for your reference.

Please give me some idea on how to do this conversion using C# or XSLT??

your help is much appreciated.

rski · #2 June 28th, 2009, 03:05 PM

I don't get it, is that data

Expand|Select|Wrap|Line Numbers

 \Acquisition of Guidant's Abbott expected to find respite \

vascular business from a volatile pharmaceutical \

market by acquiring Guidant's \

vascular business for $3.8 \

billion in a deal closed in \

April 2006. Morgan Stanley \

analysts suggest the deal will \

secure 10% earnings growth for \

Abbott for the next four years. \

written anywhere in the XML. I can see "EVENT SUMMARY \" in the XML but not the rest of data. Did I miss something?

jkmyoung · #3 July 7th, 2009, 04:53 PM

Would definitely use C#. xslt is not well suited to this task. Assuming you need a space before the \, which limits you to 65 characters total.
http://msdn.microsoft.com/en-us/library/d0z3tk9t.aspx

Something like:

Expand|Select|Wrap|Line Numbers

 
String td;

String output;

Integer index = 0;

Integer maxChars = 65;

Integer length = td.Length

Integer spaceIndex;
 
foreach td element {// get value of td element into string td. 
 
while (index + maxChars < td.length()){

  spaceIndex = td.LastIndexOf(' ', index, maxChars);
 
  if (spaceIndex == -1) spaceIndex = index + 65; // no spaces in between.

  output += td.substring(index, spaceIndex - index) + " \\";

  index = spaceIndex;

}

if (index != td.length()){

  output += td.substring(index) + " \\";

}

}

Writing XML Table in a text file

re: Writing XML Table in a text file

re: Writing XML Table in a text file

/bytes/development

/bytes/it

/bytes/about