cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Extract and parse data from an email

05-19-2020 23:27 PM - last edited 05-20-2020 08:26 AM

Django
MVP
66146 Views
Django
MVP

Extract and parse data from an email

‎05-19-2020 11:27 PM

Title: Data extraction and parsing from an email

 

Description: This Flow triggers on an email received to check its body on a dynamic number of keys to find its corresponding value. The trick is in an Apply to each loop based on an array you can manage from within the flow. The flow will find the keys and values you want to extract and parse.

 

Detailed Instructions: It’s as easy as importing the zipped flow attached, add your connection for Outlook Office 365 and it will trigger on your own inbox emails. I recommend additional filters (like a specific unique phrase in the subject or only a specific mailbox folder) so the flow will only trigger on emails that it should trigger on. Keep in mind that the flow expects a specific key to find and you can change the key in the array step of the flow. You can even change the key-value separator as explained in the video.

 

Questions: Please feel free to ask anything right here as a reply in this post.

 

 

 

watch?v=e_8hQibvbYQ

Preview file
61 KB
FlowTest-EmailgetData_20200520061714.zip
Labels:
Message 1 of 48
66,146 Views
Django
MVP
In response to Birchenall

‎10-09-2020 06:51 AM

Wow that is special indeed!
So when you use the trigger from a Shared Mailbox the From property returns an array that could have multiple items in it??

As if a single email received, can be sent from multiple email addresses... 🤔

Anyway: in my template flow, I just use this compose action to show who sent the email --> if you do not need it, just remove the step. If you are using the From Email address (or you just want to know how to get it) --> you can use the first() expression to get the first email sender in the output of the triggering action. 

However: I tested it myself and when the Power Automate Experimental feature was enabled:

Django_0-1602251310695.png

I experienced this strange behavior.

 

When I turned Experimental feature off --> the From Property of the Trigger Action would not be put in an Apply to each-loop.

Django_1-1602251419919.png

 

Could you doublecheck the same behavior?

 

Message 21 of 48
1,710 Views
0 Kudos
DVela227
Frequent Visitor
In response to Django

‎10-09-2020 07:00 AM

Hi @Django,

 

Thank you so much for the reply. Haha advanced flow stuff is always fun!

 

I was looking through your recommendation, and it was feasible, but I needed to come up with a faster solution since time was of the essence for this one. I was able to make it work by using html to text, indexOf variables, and substring expressions. It's not as pretty, but it gets the job done! I will keep the HTML table idea in my back pocket for a potential solution down the road. Thanks again!

Message 22 of 48
1,690 Views
AminBasri
Regular Visitor

‎02-14-2021 01:32 AM

Hi @Django 

I have issue with advanced HTML, meaning the fixed value and the output value is not on the same line but under fixed value for example:

 

Region:      Name:    <fixed value>
Americas     test1    <output value>
Emea         test2    <output value>

 

When I run using the HTML to text the output as below.

 

Region:
Name:
Americas
test1
Emea
test2

 

I tried to using expression first/last split with initialize variables, its worked if we have the unique value like

 

Region: Americas
Name: test1

>> first(split(variables('HTMLtoText'), 'Name')) - A
>> last(split(variables('A'), 'Region'))

Output: Americas

 

Do you have any idea and assist me?

Thanks in advance

Message 23 of 48
1,483 Views
0 Kudos
Django
MVP
In response to AminBasri

‎02-18-2021 08:40 AM

Hi @AminBasri ,

Does your raw HTML contain the table tags?

In that case you can work with the raw HTML and the <td> tags to extract cell contents.

Message 24 of 48
1,440 Views
0 Kudos
AminBasri
Regular Visitor
In response to Django

‎02-19-2021 11:46 AM

Hi @Django 

 

Yes, contains HTML tags and tried the flows you provided to someone and the result is similar that I have as below. I tried to make it flows shorter using variable and split.I can extract the value but it will take 3 value at once using this example:

AminBasri_2-1613764079628.pngAminBasri_3-1613764103289.png

 

Here is the problem when I start using split in Initialize variable - type array: 

 

 

split(outputs('Html_to_text_2')?['body'], ' ') >> space between two quote as delimiter

 

 

because its split between space thus the output will be:

 

 

[
"00:00", >>[0]
"UTC",   >>[1]
"Paris", >>[2]
"EMEA"   >>[3]
]

 

 

by selecting index [0], the output is "00:00"

 

I am stuck at here which I need two/three character "00:00 UTC" as single line but the result not what I want

Even if I can selected two index and combine to make single line 

 

 

variables('array')[0] variables('array')[1] = 00:00 UTC

 

 

but the value is dynamic so its not best option to select index 0 and 1.

 

For example:

00:00 AM UTC 

It will be: 

 

 

[
"00:00", >>[0]
"AM",    >>[1]
"UTC",   >>[2]
"Paris", >>[3]
"EMEA"   >>[4]
]

 

 

Thanks in advance.

@Django wrote:

Hi @AminBasri ,

Does your raw HTML contain the table tags?

In that case you can work with the raw HTML and the <td> tags to extract cell contents.

 

Message 25 of 48
1,424 Views
0 Kudos
Django
MVP

‎02-19-2021 02:45 PM

I see @AminBasri... so the raw HTML does not contain all values that you want in separate <td></td> tags? 

If the raw HTML would have correct tables defined 00:00 AM UTC would be between these tags making the split easier.

 

Your challenge is to discover business rules which will match all your to-be-supported cases...

Could you say that the last index of your split is always the Region with one word?

Then the preceding index would always be the Location with one word and all preceding indexes together (if multiple) would be the time?

Message 26 of 48
1,413 Views
0 Kudos
AminBasri
Regular Visitor
In response to Django

‎02-22-2021 05:14 AM

Hi @Django ,

 

Its contains HTML <td></td>, I am sorry for not realize that you asked before. 😅

Here is raw HTML that I have when view the source.

 

 

<html
	xmlns:v="urn:schemas-microsoft-com:vml"
	xmlns:o="urn:schemas-microsoft-com:office:office"
	xmlns:w="urn:schemas-microsoft-com:office:word"
	xmlns:m="http://schemas.microsoft.com/office/2004/12/omml"
	xmlns="http://www.w3.org/TR/REC-html40">
	<head>
		<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
			<meta name=Generator content="Microsoft Word 15 (filtered medium)">
				<style>
					<!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Georgia;
	panose-1:2 4 5 2 5 4 5 2 3 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
-->
				</style>
				<!--[if gte mso 9]>
				<xml>
					<o:shapedefaults v:ext="edit" spidmax="1026" />
				</xml>
				<![endif]-->
				<!--[if gte mso 9]>
				<xml>
					<o:shapelayout v:ext="edit">
						<o:idmap v:ext="edit" data="1" />
					</o:shapelayout>
				</xml>
				<![endif]-->
			</head>
			<body lang=EN-MY link="#0563C1" vlink="#954F72" style='word-wrap:break-word'>
				<div class=WordSection1>
					<p class=MsoNormal>
						<o:p>&nbsp;</o:p>
					</p>
					<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=235 style='width:176.0pt;margin-left:-.05pt;border-collapse:collapse'>
						<tr style='height:14.4pt'>
							<td width=69 nowrap valign=bottom style='width:52.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<b>
										<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Date:
											<o:p></o:p>
										</span>
									</b>
								</p>
							</td>
							<td width=79 nowrap valign=bottom style='width:59.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<b>
										<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Incident:
											<o:p></o:p>
										</span>
									</b>
								</p>
							</td>
							<td width=87 nowrap valign=bottom style='width:65.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<b>
										<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Segments:
											<o:p></o:p>
										</span>
									</b>
								</p>
							</td>
						</tr>
						<tr style='height:14.4pt'>
							<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal align=right style='text-align:right'>
									<span style='color:black;mso-fareast-language:EN-MY'>12/2/2021
										<o:p></o:p>
									</span>
								</p>
							</td>
							<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<span style='color:black;mso-fareast-language:EN-MY'>SF123
										<o:p></o:p>
									</span>
								</p>
							</td>
							<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<span style='color:black;mso-fareast-language:EN-MY'>A
										<o:p></o:p>
									</span>
								</p>
							</td>
						</tr>
						<tr style='height:14.4pt'>
							<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;
										<o:p></o:p>
									</span>
								</p>
							</td>
							<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;
										<o:p></o:p>
									</span>
								</p>
							</td>
							<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;
										<o:p></o:p>
									</span>
								</p>
							</td>
						</tr>
						<tr style='height:14.4pt'>
							<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<b>
										<span style='color:black;mso-fareast-language:EN-MY'>Course:
											<o:p></o:p>
										</span>
									</b>
								</p>
							</td>
							<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<b>
										<span style='color:black;mso-fareast-language:EN-MY'>Location:
											<o:p></o:p>
										</span>
									</b>
								</p>
							</td>
							<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<b>
										<span style='color:black;mso-fareast-language:EN-MY'>Region:
											<o:p></o:p>
										</span>
									</b>
								</p>
							</td>
						</tr>
						<tr style='height:14.4pt'>
							<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<span style='color:black;mso-fareast-language:EN-MY'>Red Hat
										<o:p></o:p>
									</span>
								</p>
							</td>
							<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<span style='color:black;mso-fareast-language:EN-MY'>Paris
										<o:p></o:p>
									</span>
								</p>
							</td>
							<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<span style='color:black;mso-fareast-language:EN-MY'>EMEA
										<o:p></o:p>
									</span>
								</p>
							</td>
						</tr>
					</table>
					<p class=MsoNormal>
						<o:p>&nbsp;</o:p>
					</p>
					<p class=MsoNormal>EndText
						<o:p></o:p>
					</p>
				</div>
			</body>
		</html>

 

 

 

The last index that I have used is "EndText" and the first index is "Time:"

When output from this Split would be between them.

 

Now I also realize that I can take the value  from "Time" because have fixed index which is UTC.

if I do something like this

 

InitVar - type string

 

first(split(output('html_to_text'), 'UTC'))  >> A

last(split(variables('A'), 'Region')

 

 

Result: 00:00 or 00:00 AM

 

Maybe the example I that give is not suitable because its clearly see the solution, my bad .

 

So lets change the the variable Time to Course

 

 

Course:     Location:    Region:
Red Hat     Paris        EMEA

 

 

Thanks in advance.

Message 27 of 48
1,373 Views
0 Kudos
Django
MVP
In response to AminBasri

‎02-22-2021 07:44 AM

Ok so your raw HTML is consistent (there is a lot of formatting /styling going on but it seems to be consistent). Your email sender would be wise to catch up on CSS styling best practices in emails to make the email HTML cleaner / faster.

 

In my example flow I am splitting on <TR> and <TD> but in your HTML you would need to focus on the <TR and <TD because the closing > is interrupted with styling information. If the number of rows and the number of cells are always consistent, in the example of Red Hat you need to focus on the part:

						<tr style='height:14.4pt'>
							<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>
								<p class=MsoNormal>
									<span style='color:black;mso-fareast-language:EN-MY'>Red Hat
										<o:p></o:p>
									</span>
								</p>
							</td>

Substring the data between EN-MY'> and <o:p> to get Red Hat.

 With minor adjustments of my example flow to split on the right tags like <tr:

Django_0-1614008131412.png

You will be able to split all the right parts of your table and once split correctly you can substring:

[
  {
    "Itemnumber": 1,
    "celldata": [
      {
        "CellData1": "<html\n\txmlns:v=\"urn:schemas-microsoft-com:vml\"\n\txmlns:o=\"urn:schemas-microsoft-com:office:office\"\n\txmlns:w=\"urn:schemas-microsoft-com:office:word\"\n\txmlns:m=\"http://schemas.microsoft.com/office/2004/12/omml\"\n\txmlns=\"http://www.w3.org/TR/REC-html40\">\n\t<head>\n\t\t<meta http-equiv=Content-Type content=\"text/html; charset=us-ascii\">\n\t\t\t<meta name=Generator content=\"Microsoft Word 15 (filtered medium)\">\n\t\t\t\t<style>\n\t\t\t\t\t<!--\n/* Font Definitions */\n@font-face\n\t{font-family:\"Cambria Math\";\n\tpanose-1:2 4 5 3 5 4 6 3 2 4;}\n@font-face\n\t{font-family:Calibri;\n\tpanose-1:2 15 5 2 2 2 4 3 2 4;}\n@font-face\n\t{font-family:Georgia;\n\tpanose-1:2 4 5 2 5 4 5 2 3 3;}\n/* Style Definitions */\np.MsoNormal, li.MsoNormal, div.MsoNormal\n\t{margin:0cm;\n\tfont-size:11.0pt;\n\tfont-family:\"Calibri\",sans-serif;\n\tmso-fareast-language:EN-US;}\n.MsoChpDefault\n\t{mso-style-type:export-only;\n\tfont-size:10.0pt;}\n@page WordSection1\n\t{size:612.0pt 792.0pt;\n\tmargin:72.0pt 72.0pt 72.0pt 72.0pt;}\ndiv.WordSection1\n\t{page:WordSection1;}\n-->\n\t\t\t\t</style>\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapedefaults v:ext=\"edit\" spidmax=\"1026\" />\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapelayout v:ext=\"edit\">\n\t\t\t\t\t\t<o:idmap v:ext=\"edit\" data=\"1\" />\n\t\t\t\t\t</o:shapelayout>\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t</head>\n\t\t\t<body lang=EN-MY link=\"#0563C1\" vlink=\"#954F72\" style='word-wrap:break-word'>\n\t\t\t\t<div class=WordSection1>\n\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t<o:p>&nbsp;</o:p>\n\t\t\t\t\t</p>\n\t\t\t\t\t<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=235 style='width:176.0pt;margin-left:-.05pt;border-collapse:collapse'>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Date:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData2": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Incident:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData3": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Segments:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData4": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal align=right style='text-align:right'>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>12/2/2021\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData5": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>SF123\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData6": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>A\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData7": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData8": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData9": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData10": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Course:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData11": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Location:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData12": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Region:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData13": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Red Hat\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData14": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Paris\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData15": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>EMEA\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      }
    ]
  },
  {
    "Itemnumber": 2,
    "celldata": [
      {
        "CellData1": "<html\n\txmlns:v=\"urn:schemas-microsoft-com:vml\"\n\txmlns:o=\"urn:schemas-microsoft-com:office:office\"\n\txmlns:w=\"urn:schemas-microsoft-com:office:word\"\n\txmlns:m=\"http://schemas.microsoft.com/office/2004/12/omml\"\n\txmlns=\"http://www.w3.org/TR/REC-html40\">\n\t<head>\n\t\t<meta http-equiv=Content-Type content=\"text/html; charset=us-ascii\">\n\t\t\t<meta name=Generator content=\"Microsoft Word 15 (filtered medium)\">\n\t\t\t\t<style>\n\t\t\t\t\t<!--\n/* Font Definitions */\n@font-face\n\t{font-family:\"Cambria Math\";\n\tpanose-1:2 4 5 3 5 4 6 3 2 4;}\n@font-face\n\t{font-family:Calibri;\n\tpanose-1:2 15 5 2 2 2 4 3 2 4;}\n@font-face\n\t{font-family:Georgia;\n\tpanose-1:2 4 5 2 5 4 5 2 3 3;}\n/* Style Definitions */\np.MsoNormal, li.MsoNormal, div.MsoNormal\n\t{margin:0cm;\n\tfont-size:11.0pt;\n\tfont-family:\"Calibri\",sans-serif;\n\tmso-fareast-language:EN-US;}\n.MsoChpDefault\n\t{mso-style-type:export-only;\n\tfont-size:10.0pt;}\n@page WordSection1\n\t{size:612.0pt 792.0pt;\n\tmargin:72.0pt 72.0pt 72.0pt 72.0pt;}\ndiv.WordSection1\n\t{page:WordSection1;}\n-->\n\t\t\t\t</style>\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapedefaults v:ext=\"edit\" spidmax=\"1026\" />\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapelayout v:ext=\"edit\">\n\t\t\t\t\t\t<o:idmap v:ext=\"edit\" data=\"1\" />\n\t\t\t\t\t</o:shapelayout>\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t</head>\n\t\t\t<body lang=EN-MY link=\"#0563C1\" vlink=\"#954F72\" style='word-wrap:break-word'>\n\t\t\t\t<div class=WordSection1>\n\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t<o:p>&nbsp;</o:p>\n\t\t\t\t\t</p>\n\t\t\t\t\t<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=235 style='width:176.0pt;margin-left:-.05pt;border-collapse:collapse'>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Date:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData2": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Incident:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData3": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Segments:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData4": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal align=right style='text-align:right'>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>12/2/2021\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData5": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>SF123\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData6": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>A\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData7": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData8": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData9": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData10": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Course:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData11": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Location:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData12": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Region:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData13": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Red Hat\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData14": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Paris\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData15": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>EMEA\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      }
    ]
  },
  {
    "Itemnumber": 3,
    "celldata": [
      {
        "CellData1": "<html\n\txmlns:v=\"urn:schemas-microsoft-com:vml\"\n\txmlns:o=\"urn:schemas-microsoft-com:office:office\"\n\txmlns:w=\"urn:schemas-microsoft-com:office:word\"\n\txmlns:m=\"http://schemas.microsoft.com/office/2004/12/omml\"\n\txmlns=\"http://www.w3.org/TR/REC-html40\">\n\t<head>\n\t\t<meta http-equiv=Content-Type content=\"text/html; charset=us-ascii\">\n\t\t\t<meta name=Generator content=\"Microsoft Word 15 (filtered medium)\">\n\t\t\t\t<style>\n\t\t\t\t\t<!--\n/* Font Definitions */\n@font-face\n\t{font-family:\"Cambria Math\";\n\tpanose-1:2 4 5 3 5 4 6 3 2 4;}\n@font-face\n\t{font-family:Calibri;\n\tpanose-1:2 15 5 2 2 2 4 3 2 4;}\n@font-face\n\t{font-family:Georgia;\n\tpanose-1:2 4 5 2 5 4 5 2 3 3;}\n/* Style Definitions */\np.MsoNormal, li.MsoNormal, div.MsoNormal\n\t{margin:0cm;\n\tfont-size:11.0pt;\n\tfont-family:\"Calibri\",sans-serif;\n\tmso-fareast-language:EN-US;}\n.MsoChpDefault\n\t{mso-style-type:export-only;\n\tfont-size:10.0pt;}\n@page WordSection1\n\t{size:612.0pt 792.0pt;\n\tmargin:72.0pt 72.0pt 72.0pt 72.0pt;}\ndiv.WordSection1\n\t{page:WordSection1;}\n-->\n\t\t\t\t</style>\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapedefaults v:ext=\"edit\" spidmax=\"1026\" />\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapelayout v:ext=\"edit\">\n\t\t\t\t\t\t<o:idmap v:ext=\"edit\" data=\"1\" />\n\t\t\t\t\t</o:shapelayout>\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t</head>\n\t\t\t<body lang=EN-MY link=\"#0563C1\" vlink=\"#954F72\" style='word-wrap:break-word'>\n\t\t\t\t<div class=WordSection1>\n\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t<o:p>&nbsp;</o:p>\n\t\t\t\t\t</p>\n\t\t\t\t\t<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=235 style='width:176.0pt;margin-left:-.05pt;border-collapse:collapse'>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Date:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData2": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Incident:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData3": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Segments:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData4": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal align=right style='text-align:right'>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>12/2/2021\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData5": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>SF123\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData6": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>A\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData7": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData8": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData9": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData10": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Course:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData11": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Location:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData12": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Region:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData13": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Red Hat\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData14": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Paris\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData15": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>EMEA\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      }
    ]
  },
  {
    "Itemnumber": 4,
    "celldata": [
      {
        "CellData1": "<html\n\txmlns:v=\"urn:schemas-microsoft-com:vml\"\n\txmlns:o=\"urn:schemas-microsoft-com:office:office\"\n\txmlns:w=\"urn:schemas-microsoft-com:office:word\"\n\txmlns:m=\"http://schemas.microsoft.com/office/2004/12/omml\"\n\txmlns=\"http://www.w3.org/TR/REC-html40\">\n\t<head>\n\t\t<meta http-equiv=Content-Type content=\"text/html; charset=us-ascii\">\n\t\t\t<meta name=Generator content=\"Microsoft Word 15 (filtered medium)\">\n\t\t\t\t<style>\n\t\t\t\t\t<!--\n/* Font Definitions */\n@font-face\n\t{font-family:\"Cambria Math\";\n\tpanose-1:2 4 5 3 5 4 6 3 2 4;}\n@font-face\n\t{font-family:Calibri;\n\tpanose-1:2 15 5 2 2 2 4 3 2 4;}\n@font-face\n\t{font-family:Georgia;\n\tpanose-1:2 4 5 2 5 4 5 2 3 3;}\n/* Style Definitions */\np.MsoNormal, li.MsoNormal, div.MsoNormal\n\t{margin:0cm;\n\tfont-size:11.0pt;\n\tfont-family:\"Calibri\",sans-serif;\n\tmso-fareast-language:EN-US;}\n.MsoChpDefault\n\t{mso-style-type:export-only;\n\tfont-size:10.0pt;}\n@page WordSection1\n\t{size:612.0pt 792.0pt;\n\tmargin:72.0pt 72.0pt 72.0pt 72.0pt;}\ndiv.WordSection1\n\t{page:WordSection1;}\n-->\n\t\t\t\t</style>\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapedefaults v:ext=\"edit\" spidmax=\"1026\" />\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapelayout v:ext=\"edit\">\n\t\t\t\t\t\t<o:idmap v:ext=\"edit\" data=\"1\" />\n\t\t\t\t\t</o:shapelayout>\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t</head>\n\t\t\t<body lang=EN-MY link=\"#0563C1\" vlink=\"#954F72\" style='word-wrap:break-word'>\n\t\t\t\t<div class=WordSection1>\n\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t<o:p>&nbsp;</o:p>\n\t\t\t\t\t</p>\n\t\t\t\t\t<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=235 style='width:176.0pt;margin-left:-.05pt;border-collapse:collapse'>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Date:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData2": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Incident:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData3": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Segments:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData4": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal align=right style='text-align:right'>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>12/2/2021\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData5": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>SF123\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData6": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>A\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData7": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData8": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData9": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData10": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Course:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData11": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Location:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData12": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Region:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData13": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Red Hat\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData14": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Paris\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData15": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>EMEA\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      }
    ]
  },
  {
    "Itemnumber": 5,
    "celldata": [
      {
        "CellData1": "<html\n\txmlns:v=\"urn:schemas-microsoft-com:vml\"\n\txmlns:o=\"urn:schemas-microsoft-com:office:office\"\n\txmlns:w=\"urn:schemas-microsoft-com:office:word\"\n\txmlns:m=\"http://schemas.microsoft.com/office/2004/12/omml\"\n\txmlns=\"http://www.w3.org/TR/REC-html40\">\n\t<head>\n\t\t<meta http-equiv=Content-Type content=\"text/html; charset=us-ascii\">\n\t\t\t<meta name=Generator content=\"Microsoft Word 15 (filtered medium)\">\n\t\t\t\t<style>\n\t\t\t\t\t<!--\n/* Font Definitions */\n@font-face\n\t{font-family:\"Cambria Math\";\n\tpanose-1:2 4 5 3 5 4 6 3 2 4;}\n@font-face\n\t{font-family:Calibri;\n\tpanose-1:2 15 5 2 2 2 4 3 2 4;}\n@font-face\n\t{font-family:Georgia;\n\tpanose-1:2 4 5 2 5 4 5 2 3 3;}\n/* Style Definitions */\np.MsoNormal, li.MsoNormal, div.MsoNormal\n\t{margin:0cm;\n\tfont-size:11.0pt;\n\tfont-family:\"Calibri\",sans-serif;\n\tmso-fareast-language:EN-US;}\n.MsoChpDefault\n\t{mso-style-type:export-only;\n\tfont-size:10.0pt;}\n@page WordSection1\n\t{size:612.0pt 792.0pt;\n\tmargin:72.0pt 72.0pt 72.0pt 72.0pt;}\ndiv.WordSection1\n\t{page:WordSection1;}\n-->\n\t\t\t\t</style>\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapedefaults v:ext=\"edit\" spidmax=\"1026\" />\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapelayout v:ext=\"edit\">\n\t\t\t\t\t\t<o:idmap v:ext=\"edit\" data=\"1\" />\n\t\t\t\t\t</o:shapelayout>\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t</head>\n\t\t\t<body lang=EN-MY link=\"#0563C1\" vlink=\"#954F72\" style='word-wrap:break-word'>\n\t\t\t\t<div class=WordSection1>\n\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t<o:p>&nbsp;</o:p>\n\t\t\t\t\t</p>\n\t\t\t\t\t<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=235 style='width:176.0pt;margin-left:-.05pt;border-collapse:collapse'>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Date:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData2": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Incident:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData3": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Segments:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData4": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal align=right style='text-align:right'>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>12/2/2021\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData5": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>SF123\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData6": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>A\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData7": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData8": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData9": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData10": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Course:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData11": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Location:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData12": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Region:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData13": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Red Hat\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData14": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Paris\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData15": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>EMEA\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      }
    ]
  },
  {
    "Itemnumber": 6,
    "celldata": [
      {
        "CellData1": "<html\n\txmlns:v=\"urn:schemas-microsoft-com:vml\"\n\txmlns:o=\"urn:schemas-microsoft-com:office:office\"\n\txmlns:w=\"urn:schemas-microsoft-com:office:word\"\n\txmlns:m=\"http://schemas.microsoft.com/office/2004/12/omml\"\n\txmlns=\"http://www.w3.org/TR/REC-html40\">\n\t<head>\n\t\t<meta http-equiv=Content-Type content=\"text/html; charset=us-ascii\">\n\t\t\t<meta name=Generator content=\"Microsoft Word 15 (filtered medium)\">\n\t\t\t\t<style>\n\t\t\t\t\t<!--\n/* Font Definitions */\n@font-face\n\t{font-family:\"Cambria Math\";\n\tpanose-1:2 4 5 3 5 4 6 3 2 4;}\n@font-face\n\t{font-family:Calibri;\n\tpanose-1:2 15 5 2 2 2 4 3 2 4;}\n@font-face\n\t{font-family:Georgia;\n\tpanose-1:2 4 5 2 5 4 5 2 3 3;}\n/* Style Definitions */\np.MsoNormal, li.MsoNormal, div.MsoNormal\n\t{margin:0cm;\n\tfont-size:11.0pt;\n\tfont-family:\"Calibri\",sans-serif;\n\tmso-fareast-language:EN-US;}\n.MsoChpDefault\n\t{mso-style-type:export-only;\n\tfont-size:10.0pt;}\n@page WordSection1\n\t{size:612.0pt 792.0pt;\n\tmargin:72.0pt 72.0pt 72.0pt 72.0pt;}\ndiv.WordSection1\n\t{page:WordSection1;}\n-->\n\t\t\t\t</style>\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapedefaults v:ext=\"edit\" spidmax=\"1026\" />\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t\t<!--[if gte mso 9]>\n\t\t\t\t<xml>\n\t\t\t\t\t<o:shapelayout v:ext=\"edit\">\n\t\t\t\t\t\t<o:idmap v:ext=\"edit\" data=\"1\" />\n\t\t\t\t\t</o:shapelayout>\n\t\t\t\t</xml>\n\t\t\t\t<![endif]-->\n\t\t\t</head>\n\t\t\t<body lang=EN-MY link=\"#0563C1\" vlink=\"#954F72\" style='word-wrap:break-word'>\n\t\t\t\t<div class=WordSection1>\n\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t<o:p>&nbsp;</o:p>\n\t\t\t\t\t</p>\n\t\t\t\t\t<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=235 style='width:176.0pt;margin-left:-.05pt;border-collapse:collapse'>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Date:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData2": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Incident:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData3": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:#0D0D0D;mso-fareast-language:EN-MY'>Segments:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData4": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal align=right style='text-align:right'>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>12/2/2021\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData5": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>SF123\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData6": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>A\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData7": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData8": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData9": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>&nbsp;\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData10": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Course:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData11": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Location:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData12": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<b>\n\t\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Region:\n\t\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t\t</b>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData13": "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr style='height:14.4pt'>\n\t\t\t\t\t\t\t<td width=69 nowrap valign=bottom style='width:52.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Red Hat\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData14": "\n\t\t\t\t\t\t\t<td width=79 nowrap valign=bottom style='width:59.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>Paris\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      },
      {
        "CellData15": "\n\t\t\t\t\t\t\t<td width=87 nowrap valign=bottom style='width:65.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:14.4pt'>\n\t\t\t\t\t\t\t\t<p class=MsoNormal>\n\t\t\t\t\t\t\t\t\t<span style='color:black;mso-fareast-language:EN-MY'>EMEA\n\t\t\t\t\t\t\t\t\t\t<o:p></o:p>\n\t\t\t\t\t\t\t\t\t</span>\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t"
      }
    ]
  }
]

You seem to use 6 rows with 15 cells in each row to show a mere item with only 6 values... Therefore you would also need to change the logic to account for the fact that your data is scattered over multiple rows, but if it is consistent you know that Cell 1 of Row 1 will always be Date, Cell 1 of Row 3 will always be Course etc... based on the Red Hat example above, you can extract the values between EN-MY'> and <o:p> and put that string value in a variable based on Cell x of Row y.

 

Again: your best bet is to see if you can ask the email sender to input the data in a way that you can more easily handle it (like one row per item, fixed order of data in that row).
Otherwise accept that you need to do a lot of extracting to get the data you want.

Message 28 of 48
1,362 Views
sinanaalmac111
Helper I
Helper I

‎02-23-2021 12:00 PM

Hi there,
This was very amazing. It opened a new window in my thoughts.
is there a way to get a table day from the email body?

like this:

Satış Organizasyonu

Sipariş Veren

Teslim Alan

SAS

Malzeme

Miktar

ÖB

Sevk (shipping cond)

Neden Kodu or Blokaj

ZRE/ZTA No

LCS ADI

3001

15031584

15031584

BOR2020000000748

67912372

48

PC

29

T03

 

Eric Mactores

I would be grateful if you know anything about this issue

Best regards

Sinan

Message 29 of 48
1,350 Views
0 Kudos
Django
MVP

‎02-23-2021 11:48 PM

Hi @sinanaalmac111, 

If you would have a look at all the comments above you should get all the info you need.

In your example it would be better to restructure the data but if your email always has X columns, this structure should also be extractable.

Message 30 of 48
1,345 Views