02-22-2021 05:14 AM - last edited 02-22-2021 05:36 AM
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
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:
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.
Could you doublecheck the same behavior?
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!
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
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.
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:
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.
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?
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> </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'>
<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'>
<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'>
<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> </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.
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:
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> </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'> \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'> \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'> \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> </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'> \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'> \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'> \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> </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'> \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'> \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'> \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> </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'> \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'> \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'> \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> </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'> \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'> \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'> \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> </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'> \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'> \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'> \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.
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
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.