How to extract text inside paragraph in Inbound action or regex by scanning the entire html body

Community Alums
Not applicable

‎11-06-2024 08:28 AM - edited ‎11-06-2024 08:29 AM

Hi Team,

 

We have inbound action written wherein we are able to parse all the fields using "email.body.field name"  but there is a field called as description I am not able to fetch it as its data is inside the <p> tag

 

Can you see the below html and help me to extract "This is the description field for the incident" by scanning the entire html

 

 

 Description:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
<p style="margin-top:0; margin-bottom:10px; margin:1em 0; margin:0; margin-top:0">
This is the description field for the incident</p>

 

 

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<strong>
<div><font face="Tahoma" color="#000000" size="2">&nbsp;</font></div>
</strong>
<hr tabindex="-1" style="display:inline-block; width:98%">
<font face="Tahoma" size="2"><b>From:</b> ;<br>
<b>Sent:</b> Wednesday, November 6, 2024 3:08:09 PM (UTC+02:00)tt<br>
<b>To:</b> tt-TAC &lt;tt-t@t.com&gt;<br>
<b>Subject:</b> [EXTERNAL] [trackSpace] Updates for GOA-5277: Test incident 2024-11-06_001<br>
</font><br>
<div></div>
<div>
<div style="display:none!important; display:none; visibility:hidden; font-size:1px; color:#ffffff; line-height:1px; height:0px; max-height:0px; opacity:0; overflow:hidden">
Message Title tt Systems trackSpace This issue has been created This issue is now assigned to you. Ground Ops Apps / GOA-5277 Open Test incident 2024-11-06_001 Issue created tt created this issue on 2024-11-06 13: 04</div>
<div style="display:none!important; display:none; visibility:hidden; font-size:1px; color:#ffffff; line-height:1px; max-height:0px; opacity:0; overflow:hidden">
</div>
<style>
<!--
#pfptBanner3nz67wb
	{display:block!important;
	visibility:visible!important;
	opacity:1!important;
	background-color:#D0D8DC!important;
	max-width:none!important;
	max-height:none!important}
-->
</style>
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
<base href="https://trackspace.lhsystems.com">
<table id="background-table" cellpadding="0" cellspacing="0" width="100%" style="padding:10px!important; border-collapse:collapse">
<tbody>
<tr>
<td id="LSYTitle" style="background-color:#05164d; color:#ffffff; padding:4px!important; border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
&nbsp;&nbsp;<b style="color:#ffffff">tt Systems trackSpace</b></td>
</tr>
</tbody>
</table>
<table width="100%" align="left" style="border-collapse:collapse">
<tbody>
<tr>
<td align="left" style="padding:15px!important; border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
<table width="100%" style="max-width:960px; padding:10px; border:1; border-collapse:collapse">
<tbody>
<tr>
<td width="100%" align="left" style="width:100%; border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
<table id="header-history" style="border-collapse:collapse">
<tbody>
<tr>
<td colspan="2" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
This issue has been <span class="aui-lozenge aui-lozenge-new" bgcolor="#5243aa" style="background:#dfe1e6; border-top:3px solid #dfe1e6; border-bottom:3px solid #dfe1e6; border-left:6px solid #dfe1e6; border-right:6px solid #dfe1e6; border-radius:3px; color:#253858; display:inline-block; font-size:10px; font-weight:bold; line-height:99.0%; margin:0; padding:0; text-align:center; text-decoration:none; text-transform:uppercase; vertical-align:text-bottom; background-color:#5243aa; border-color:#5243aa; color:#ffffff">
created</span></td>
</tr>
<tr>
<td colspan="2" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
This issue is now <strong>assigned to you</strong>.</td>
</tr>
</tbody>
</table>
<table style="border-collapse:collapse">
<tbody>
<tr>
<td class="spacer-10" height="10" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; height:10px; font-size:10px; line-height:10px">
&nbsp;</td>
</tr>
</tbody>
</table>
<table class="structure" width="100%" style="border-collapse:collapse; border-radius:6px; border:solid 2px #ebecf0; border-collapse:separate">
<tbody>
<tr>
<td style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
</td>
<td class="spacer-10" height="10" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; height:10px; font-size:10px; line-height:10px">
&nbsp;</td>
</tr>
<tr>
<td class="header updates" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; padding-left:20px; padding-right:20px">
<table id="header-top" width="100%" style="width:100%; border-collapse:collapse">
<tbody>
<tr>
<td style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
<table style="border-collapse:collapse">
<tbody>
<tr>
<td valign="middle" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
<a href="https://trackspace.lhsystems.com/browse/GOA" style="text-decoration:none; color:#0000aa">Ground Ops Apps</a></td>
<td valign="middle" class="project-spacer" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; padding-left:8px; padding-right:8px; vertical-align:middle">
/</td>
<td valign="middle" class="issue-key" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; padding-left:5px; vertical-align:middle">
<a href="https://trackspace.lhsystems.com/browse/GOA-5277" style="text-decoration:none; color:#0000aa">GOA-5277</a></td>
<td valign="middle" class="issue-status" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; padding-left:8px; vertical-align:middle">
<span class="aui-lozenge" style="background:#dfe1e6; border-top:3px solid #dfe1e6; border-bottom:3px solid #dfe1e6; border-left:6px solid #dfe1e6; border-right:6px solid #dfe1e6; border-radius:3px; color:#253858; display:inline-block; font-size:10px; font-weight:bold; line-height:99.0%; margin:0; padding:0; text-align:center; text-decoration:none; text-transform:uppercase; vertical-align:text-bottom">Open</span></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="issue-summary" valign="top" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; padding-top:3px">
<h1 style="color:#172b4d; margin:0; margin-top:0; color:#172b4d; font-size:22px; font-weight:500; line-height:1.25; letter-spacing:-0.01em; text-transform:none">
Test incident 2024-11-06_001</h1>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="spacer-10" height="10" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; height:10px; font-size:10px; line-height:10px">
&nbsp;</td>
</tr>
<tr>
<td id="new-issue-header" class="section-header" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; padding-left:20px; padding-right:20px">
<table width="100%" style="width:100%; border-collapse:collapse">
<tbody>
<tr>
<td width="100%" style="width:100%; border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
<h2 style="color:#172b4d; margin:0; margin-top:0; color:#172b4d; font-size:18px; font-weight:500; line-height:1.5; letter-spacing:-0.008em; text-transform:none">
Issue created</h2>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="spacer-10" height="10" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; height:10px; font-size:10px; line-height:10px">
&nbsp;</td>
</tr>
<tr>
<td class="updates" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; padding-left:20px; padding-right:20px">
<table width="100%" class="group new-issue-group" style="border-collapse:collapse">
<tbody>
<tr class="group-header">
<td class="author" width="32" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; width:32px; vertical-align:top">
<img src="/sys_attachment.do?sys_id=960eeac81b359610a0bdeb536b4bcb7c" width="24" height="24" alt="cid:jira-generated-image-avatar-5d83ca4d-0cbe-4bdc-a6d8-8686ecad6b84" style="outline:none; text-decoration:none; display:block; border-radius:100.0%"></td>
<td class="heading" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; padding-top:3px; vertical-align:top">
<strong>tt</strong> created this issue on 2024-11-06 13:04</td>
</tr>
<tr>
<td colspan="2" class="spacer-10" height="10" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; height:10px; font-size:10px; line-height:10px">
&nbsp;</td>
</tr>
<tr class="group-content">
<td class="author spacer" width="32" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; width:32px; vertical-align:top">
</td>
<td class="updates-diff" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
<table style="border-collapse:collapse">
<tbody>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Summary:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
Test incident 2024-11-06_001</td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Issue Type:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
<img src="/sys_attachment.do?sys_id=9a0eeac81b359610a0bdeb536b4bcb7f" height="16" width="16" border="0" alt="cid:jira-generated-image-avatar-9537f5b8-3c53-4c5c-b279-d4a785c57bee" style="outline:none; text-decoration:none; vertical-align:text-bottom">&nbsp;Incident</td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Assignee:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
<a class="user-hover" rel="servicedesk_ibm" id="email_servicedesk_ibm" href="https://trackspace.lhsystems.com/secure/ViewProfile.jspa?name=servicedesk_ibm" style="color:#0000aa">IBM ServiceNow (IBM)</a></td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Components:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
TAC</td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Created:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
2024-11-06 13:04</td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Reporter:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
<a class="user-hover" rel="rtomescu" id="email_rtomescu" href="https://trackspace.lhsystems.com/secure/ViewProfile.jspa?name=rtomescu" style="color:#0000aa">pp</a></td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Detected in:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
Development</td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Impact:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
2 - Site/Dept</td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Interference Level:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
2 - Partial failure</td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Scope:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
Regular incident</td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Service type:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
access / authorization error</td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Severity:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
3</td>
</tr>
<tr class="field-update">
<td valign="top" align="left" class="updates-diff-label" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; max-width:150px; vertical-align:top; color:#5e6c84; text-align:left; padding-right:10px; padding-bottom:5px">
Description:</td>
<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px">
<p style="margin-top:0; margin-bottom:10px; margin:1em 0; margin:0; margin-top:0">
This is the description field for the incident</p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<table style="border-collapse:collapse">
<tbody>
<tr>
<td class="spacer-10" height="10" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; height:10px; font-size:10px; line-height:10px">
&nbsp;</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="padding:20px!important; border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
<table id="header-actions" style="border-collapse:collapse">
<tbody>
<tr>
<td class="author spacer" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
<a href="https://trackspace.lhsystems.com/browse/GOA-5277" style="color:#0000aa">View issue</a> &nbsp;&nbsp;·&nbsp;&nbsp; <a href="https://trackspace.lhsystems.com/browse/GOA-5277#add-comment" style="color:#0000aa">Add comment</a></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="padding:20px!important; border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
&nbsp;</td>
</tr>
</tbody>
</table>
<table class="footer-text" width="100%" style="border-collapse:collapse; color:#5e6c84; font-size:12px">
<tbody>
<tr>
<td class="spacer-10" height="10" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; height:10px; font-size:10px; line-height:10px">
&nbsp;</td>
</tr>
<tr>
<td align="center" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px">
This message is automatically generated by trackSpace.<br>
To access trackSpace, go to: <a href="https://trackspace.lhsystems.com" style="color:#0000aa">https://trackspace.lhsystems.com</a> - <a href="https://tt.com/static/data-privacy-policy.html" style="color:#0000aa">Data Privacy Policy</a> - <a href="https://trackspace.lhsystems.com/static/terms-of-use.html" style="color:#0000aa">Terms of Use</a></td>
</tr>
<tr>
<td class="spacer-10" height="10" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; height:10px; font-size:10px; line-height:10px">
&nbsp;</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>

<div>
tt<br>
tt<br>
tt<br>
tt1<br>
tt<br>
tt<br>
tt<br>
tt<br>
</div></body>
</html>

 

 

This is the description field for the incident"

0 Helpfuls
  • 414 Views
2 REPLIES 2

Najmuddin Mohd
Mega Sage

‎11-06-2024 12:00 PM

Hi @Community Alums ,
Can you check with the following Regex.

var htmlString = '<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px"><p style="margin-top:0; margin-bottom:10px; margin:1em 0; margin:0; margin-top:0">This is the description field for the incident</p>';

var regex = /<p[^>]*>(.*?)<\/p>/i;


var match = htmlString.match(regex);
var description = match ? match[1].trim() : '';

// Output the description value
gs.info(description);

 

 

Output:

*** Script: This is the description field for the incident

 

 

If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

 

Community Alums
Not applicable

‎11-07-2024 01:10 AM

it works only for the html text below:

var htmlString = '<td valign="top" align="left" class="updates-diff-content" style="border-collapse:collapse; border-spacing:0px; color:#172b4d; padding:0px; vertical-align:top; text-align:left; padding-bottom:5px"><p style="margin-top:0; margin-bottom:10px; margin:1em 0; margin:0; margin-top:0">This is the description field for the incident</p>';

But there is entire HTML body and it does not work, it gives blank output. The regex you mentioned, I already tried , it works for smaller portion but not for whole body.

0 Helpfuls