Hi!
Could someone please help me,
I need to extract specific data from emails I have exported as .txt files and paste them into excel
This is an example of an email:
From: xxxxxxxxxxxxxxxxxxxxx
Sent: Friday, December 02, 2016 11:35 AM
To: xxxxxxxxxxxxxx
Cc: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Support
Subject: xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
preparelaunch:xxxxxxxxxxxxxxxxxxxxxxxxxx
Dear User,
Please find the details of error event originated from application WILEYPLUS-ESB-APPLN below.
Error Details :
========================
Application ID : xxxxxxxxxxxxxxxx
Service Name : preparelaunch
Error Code : xxxxxxxxxxxxx
Error Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Error Type : PROCESS_ERROR
Error GUID : edd72224-7324-4b02-9abf-1e73bc12b9c9
Error Event DateTime : 02-Dec-2016 16:33:24 GMT
Error Correlation ID : Correlation ID Not Sent
Error Stack :
---------------------------------
<Begin>
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
<End>
Business Key Details :
========================
The following business keys are sent by the application.
Server ID :1115
Root Cause :Undefined
Workflow Details :
========================
$WorkflowDetails
Error GUID : edd72224-7324-4b02-9abf-1e73bc12b9c9
Error Event DateTime : 02-Dec-2016 16:33:24 GMT
Payload Details :
========================
Message Data :
---------------------------------
<Begin>
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
<End>
Sincerely,
xxxxxxxxxxxxx Services Support Team
Note: This email is system generated hence do not reply to this mail. Please reach out to appropriate
support for further details or login to : xxxxxxxxxxxxxxx
The data I need is located here:
Error Details :
========================
Application ID : xxxxxxxxxxxxxxxx
Service Name : preparelaunch
Error Code : xxxxxxxxxxxxx
Error Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Error Type : PROCESS_ERROR
Error GUID : edd72224-7324-4b02-9abf-1e73bc12b9c9
Error Event DateTime : 02-Dec-2016 16:33:24 GMT
Error Correlation ID : Correlation ID Not Sent
Error Stack :
---------------------------------
I just need to get that data (application ID, service name, error code etc....) so each text file would be one line in excel.
Thanks for your help!
Could someone please help me,
I need to extract specific data from emails I have exported as .txt files and paste them into excel
This is an example of an email:
From: xxxxxxxxxxxxxxxxxxxxx
Sent: Friday, December 02, 2016 11:35 AM
To: xxxxxxxxxxxxxx
Cc: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Support
Subject: xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
preparelaunch:xxxxxxxxxxxxxxxxxxxxxxxxxx
Dear User,
Please find the details of error event originated from application WILEYPLUS-ESB-APPLN below.
Error Details :
========================
Application ID : xxxxxxxxxxxxxxxx
Service Name : preparelaunch
Error Code : xxxxxxxxxxxxx
Error Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Error Type : PROCESS_ERROR
Error GUID : edd72224-7324-4b02-9abf-1e73bc12b9c9
Error Event DateTime : 02-Dec-2016 16:33:24 GMT
Error Correlation ID : Correlation ID Not Sent
Error Stack :
---------------------------------
<Begin>
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
<End>
Business Key Details :
========================
The following business keys are sent by the application.
Server ID :1115
Root Cause :Undefined
Workflow Details :
========================
$WorkflowDetails
Error GUID : edd72224-7324-4b02-9abf-1e73bc12b9c9
Error Event DateTime : 02-Dec-2016 16:33:24 GMT
Payload Details :
========================
Message Data :
---------------------------------
<Begin>
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
<End>
Sincerely,
xxxxxxxxxxxxx Services Support Team
Note: This email is system generated hence do not reply to this mail. Please reach out to appropriate
support for further details or login to : xxxxxxxxxxxxxxx
The data I need is located here:
Error Details :
========================
Application ID : xxxxxxxxxxxxxxxx
Service Name : preparelaunch
Error Code : xxxxxxxxxxxxx
Error Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Error Type : PROCESS_ERROR
Error GUID : edd72224-7324-4b02-9abf-1e73bc12b9c9
Error Event DateTime : 02-Dec-2016 16:33:24 GMT
Error Correlation ID : Correlation ID Not Sent
Error Stack :
---------------------------------
I just need to get that data (application ID, service name, error code etc....) so each text file would be one line in excel.
Thanks for your help!