Question
Commonwealth Bank
IN
Last activity: 3 Oct 2016 13:42 EDT
How to Read HTML and set the values in clipboard.
I have a requirement where i have HTML content. As given below as string in clipboard.
<html><head><meta http-equiv=Content-Language content=en-us><meta name=GENERATOR content=EMiSoft Vasona>
<meta name=ProgId content=EMiSoft Vasona.Editor.Document><meta http-equiv=Content-Type content=text/html; charset=windows-1252>
<title>Vasona Results File</title>
</head><body>
<p><table border=0 cellpadding=3 width=575 id=AutoNumber2 bgcolor=#F4F4F4 cellspacing=1>
<tr>
<td bgcolor=#C0C0C0 width=545 height=0 colspan=12><b>
<font face=Verdana size=2 color=#FFFFE6>Debug Data</font></b></td>
</tr>
<tr>
<td bgcolor=#FFFFFF + valign=top><b><font face=Verdana size=2>No </font></b></td>
<td bgcolor=#FFFFFF + valign=top><b><font face=Verdana size=2>Frequency MHz </font></b></td>
</tr>
<tr>
<td bgcolor=#FFFFFF + align=right><font face=Verdana size=2>1</font></td>
<td bgcolor=#FFFFFF + align=right><font face=Verdana size=2> .180</font></td>
</tr>
</table>
</body></html>
I need to get the table values and set it in pagelist.
Please reply the post if any one has the solution.
Thanks in Advance.
I have a requirement where i have HTML content. As given below as string in clipboard.
<html><head><meta http-equiv=Content-Language content=en-us><meta name=GENERATOR content=EMiSoft Vasona>
<meta name=ProgId content=EMiSoft Vasona.Editor.Document><meta http-equiv=Content-Type content=text/html; charset=windows-1252>
<title>Vasona Results File</title>
</head><body>
<p><table border=0 cellpadding=3 width=575 id=AutoNumber2 bgcolor=#F4F4F4 cellspacing=1>
<tr>
<td bgcolor=#C0C0C0 width=545 height=0 colspan=12><b>
<font face=Verdana size=2 color=#FFFFE6>Debug Data</font></b></td>
</tr>
<tr>
<td bgcolor=#FFFFFF + valign=top><b><font face=Verdana size=2>No </font></b></td>
<td bgcolor=#FFFFFF + valign=top><b><font face=Verdana size=2>Frequency MHz </font></b></td>
</tr>
<tr>
<td bgcolor=#FFFFFF + align=right><font face=Verdana size=2>1</font></td>
<td bgcolor=#FFFFFF + align=right><font face=Verdana size=2> .180</font></td>
</tr>
</table>
</body></html>
I need to get the table values and set it in pagelist.
Please reply the post if any one has the solution.
Thanks in Advance.
Have attached whole HTML content .
***Updated by Moderator: Marissa to update categories***
PWC s.r.o
SK
Hello,
have you tried to log it? You can use System -> Tools -> Logs -> Logging Level settings(I use PEGA PRPC 6.3. though) and set values for some classes to DEBUG.
I had the similar problem with SOAP connector and seeing the logs in LogViewer(I enabled httpclient.wire.header to see what I actually send to external system and it helped me a lot.
Kind regards,
Peter
Pegasystems Inc.
GB
If your HTML is guaranteed to be well-formed XML , then you can use it with a PARSE-XML rule to map elements (and attributes/values) to PRPC Properties.
See this link for an example of parsing an XML file into a PRPC model : (which happens to be quite close to your requirement - as it parses EXCEL XML format ; which is also a table/row/cell based format) : https://mesh.pega.com/docs/DOC-89988
Also attached as PDF (but some formatting lost unfortunately; so that's why I also put in the link to the original).