如何从BizTalk帮助器类中的部分html文件创建xml [英] How to create xml from part of html file in BizTalk helper class
问题描述
hi team，
我有一个要求，我在哪里收到一个包含表格的电子邮件正文。所以我把它保存为一个html文件并从中提取表格并添加了xml标签。
I have a requirement where I get the email body with a table. So I have saved it as a html file and extracted the table out of it and added xml tag to it.
现在我需要从中创建一个合适的xml。你能帮我吗？
Now I need to create a proper xml out of it. Can you please help me.
提取的html表格字符串：
Extracted html table string:
<？xml version =" 1.0"编码= QUOT; UTF-8英寸;？> < body>< table border = 0 cellspacing = 0 cellpadding = 0 style ='border-collapse：collapse; < tr style ='height：13.5pt'> < td width = 211 valign = top style ='width：158.05pt; border：solid windowtext
1.0pt;填充：0英寸在5.4英尺0英寸，5.4英尺;高度：13.5英尺'， < p< / td> < td width = 211 valign = top style ='width：158.05pt; border：solid windowtext 1.0pt; border-left：none; padding：0in 5.4pt 0in 5.4pt; height：13.5pt'> < p Form< / p> < / TD> < / TR>
< tr style ='height：12.75pt'> < td width = 211 valign = top style ='width：158.05pt; border：solid windowtext 1.0pt; border-top：none; padding：0in 5.4pt 0in 5.4pt; height：12.75pt'> < p< / td> < td width = 211 valign = top style ='width：158.05pt; border-top：none; border-left：
none; border-bottom：solid windowtext 1.0pt; border-right：solid windowtext 1.0pt ;填充：0英寸在5.4英尺0英寸，5.4英尺;高度：12.75英尺'， < p< / td> < / TR> < tr style ='height：13.5pt'> < td width = 211 valign = top style ='width：158.05pt; border：solid windowtext
1.0pt; border-top：none; padding：0in 5.4pt 0in 5.4pt; height：13.5pt'> < p< / td> < td width = 211 valign = top style ='width：158.05pt; border-top：none; border-left：none; border-bottom：solid windowtext 1.0pt; border-right：solid windowtext 1.0pt;填充：0in
5.4pt 0in 5.4pt; height：13.5pt'> < p< / td> < / TR> < tr style ='height：12.75pt'> < td width = 211 valign = top style ='width：158.05pt; border：solid windowtext 1.0pt; border-top：none; padding：0in 5.4pt 0in 5.4pt; height：12.75pt'> < p< / td>
< td width = 211 valign = top style ='width：158.05pt; border-top：none; border-left：none; border-bottom：solid windowtext 1.0pt; border-right：solid windowtext 1.0pt ;填充：0英寸在5.4英尺0英寸，5.4英尺;高度：12.75英尺'， < p 1:36 PM< / p> < / TD> < / TR> < tr
style ='height：12.75pt'> < td width = 211 valign = top style ='width：158.05pt; border：solid windowtext 1.0pt; border-top：none; padding：0in 5.4pt 0in 5.4pt; height：12.75pt'> < p日期：< / p> < / TD> < td width = 211 valign = top style ='width：158.05pt; border-top：none; border-left：
none; border-bottom：solid windowtext 1.0pt; border-right：solid windowtext 1.0pt ;填充：0英寸在5.4英尺0英寸，5.4英尺;高度：12.75英尺'， < p< / td> < / TR> < /表>< /体>
<?xml version="1.0" encoding="UTF-8"?> <body><table border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse; <tr style='height:13.5pt'> <td width=211 valign=top style='width:158.05pt;border:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:13.5pt'> <p </td> <td width=211 valign=top style='width:158.05pt;border:solid windowtext 1.0pt; border-left:none;padding:0in 5.4pt 0in 5.4pt;height:13.5pt'> <p Form</p> </td> </tr> <tr style='height:12.75pt'> <td width=211 valign=top style='width:158.05pt;border:solid windowtext 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt'> <p </td> <td width=211 valign=top style='width:158.05pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:12.75pt'> <p </td> </tr> <tr style='height:13.5pt'> <td width=211 valign=top style='width:158.05pt;border:solid windowtext 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:13.5pt'> <p </td> <td width=211 valign=top style='width:158.05pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:13.5pt'> <p </td> </tr> <tr style='height:12.75pt'> <td width=211 valign=top style='width:158.05pt;border:solid windowtext 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt'> <p </td> <td width=211 valign=top style='width:158.05pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:12.75pt'> <p 1:36PM</p> </td> </tr> <tr style='height:12.75pt'> <td width=211 valign=top style='width:158.05pt;border:solid windowtext 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:12.75pt'> <p Date:</p> </td> <td width=211 valign=top style='width:158.05pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:12.75pt'> <p </td> </tr> </table></body>
需要以下格式的xml：
Need the xml in the below format:
<？xml version =" 1.0"编码= QUOT; UTF-8英寸;？>
<?xml version="1.0" encoding="UTF-8"?>
< table>
<table>
< tr> tr_0< / tr>
<tr>tr_0</tr>
< td> td_0< / td>
<td>td_0</td>
< p> p_0< / p>
<p>p_0</p>
< / table>
</table>
谢谢和问候，
Veena Handadi
Veena Handadi
推荐答案
您好
您可以使用输入和输出结构在BizTalk中定义XML消息类型。
You can define an XML message type in BizTalk with your input and output structures.
例如，输出XML消息 -
Eg, output XML message -
< table>
<table>
< tr> tr_0< / tr>
<tr>tr_0</tr>
< td> td_0< / td>
<td>td_0</td>
< p> p_0< / p>
<p>p_0</p>
< / table>
</table>
您拥有的html字符串可以加载到输入的XML消息中，并且地图可以生成输出XML您需要的消息。只需将您的输入HTML字符串视为另一条XML消息。
The html string you have can be loaded into the typed input XML message, and a map can generate the output XML message that you require. Just think of your input HTML string as just another XML message.
这篇关于如何从BizTalk帮助器类中的部分html文件创建xml的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
