How can i extract specific text from email body?

saumitra.tiwari · May 27, 2021, 8:14am

Hey, i wanted to extract few texts from the email body and to pass it to another function. Using regex is quite tricky because the email body is not always of a specific length.

Example Email

Text to extract
impact, start time, product name, affected service

p.s.- The bottom table can have more than one value.

Divyanshu_Divyanshu · May 27, 2021, 6:39pm

@saumitra.tiwari just help me with the text output of this
will try extract all your details

saumitra.tiwari · May 28, 2021, 4:38am

Wanted to get impact, start time, product name, affected service as an output.

Divyanshu_Divyanshu · May 28, 2021, 5:40am

@saumitra.tiwari

Email body text so that i can extract it.

Deepan_Baskaran · May 28, 2021, 5:03pm

try to read the email as html and then extract using regex
vba can easily extract those values, create a macro and invoke it.

saumitra.tiwari · May 31, 2021, 4:47am

@"

P1 - Issue Status Update

We are sorry for any inconvenience this may have caused.
[Issue Status Update]

[Border]

[https://support.sap.com/content/dam/support/notifications/BC4L/Other/ProgressBar/status_update_progress_bar.jpg]

[Border]

Dear Customer,

As previously reported, we identified a degradation affecting your service.

Impact Prior to Resolution: In the North America, EMEA, and Concur Cloud for Public Sector Data Centers, Travel searches using the Sabre GDS service are 20% below expected level. Affected users may experience an error message “We encountered an issue which prevented us from completing your request” after clicking the Search button. To check if your company is affected by this incident please log onto the Personalized Concur Open website.

Start Time: 06:22 UTC on 21 May 2021

Status Update: The Incident Response Team has engaged our GDS vendor Sabre and confirmed there is an outage on the Sabre side. We are investigating the issue with Sabre. Our next scheduled update will be in one hour or sooner should a significant change occur.

We appreciate your patience as we work to resolve this issue. We will keep you updated until the issue is resolved.
Product Name
Affected Service
SAP Concur
Travel

[Border]

Keep Up to Date

Visit Personalized Concur Open https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fopen.concur.com%2Fpco&data=04|01|Saumitra.Tiwari%40cerner.com|5a6652b4419b4451ca6208d9242b3f83|fbc493a80d244454a815f4ca58e8c09d|0|0|637580590431822828|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|1000&sdata=vUDTv%2BYRvnTDVZ22%2Fp22aCHsxDmccA5niMFRWMpuMrE%3D&reserved=0 to see a history of all updates related to this issue and subscribe to notification emails.

[Border]

Let’s Run Better Together!
Your SAP Team
[Border]

[Border]

Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank.

This e-mail is sent to you by SAP SE on behalf of SAP’s legal entities worldwidehttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sap.com%2Fdam%2Fsite%2Fcorporate%2Flegal%2Fsap-legal-entities.pdf&data=04|01|Saumitra.Tiwari%40cerner.com|5a6652b4419b4451ca6208d9242b3f83|fbc493a80d244454a815f4ca58e8c09d|0|0|637580590431842814|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|1000&sdata=rJKN0O6lIDY6J85mpt9qF%2B5o5jeFhLw0uYsYmfS19TE%3D&reserved=0 and if you would like to know who your specific data controller is, please click here to e-mail WebMaster@sap.com mailto:WebMaster@sap.com.

This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation.

This e-mail provides material about SAP products and services that are related to your contract. If your role has changed and these communications are no longer relevant, please click on this linkhttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fopen.concur.com%2Fpco%3Futm_medium%3Demail%26utm_source%3Dp_subscr&data=04|01|Saumitra.Tiwari%40cerner.com|5a6652b4419b4451ca6208d9242b3f83|fbc493a80d244454a815f4ca58e8c09d|0|0|637580590431842814|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|1000&sdata=zT7Lklf8mr9KTK796s7JHNyBI4zpkY8qWQSRWGnwc9I%3D&reserved=0 to be removed.

To ensure you continue to receive SAP related information properly please add sap@mailsap.com mailto:sap@mailsap.com to your address book or safe senders list.

"

saumitra.tiwari · May 31, 2021, 11:47am

can you please provide me with an example? As i am very new to RPA

Divyanshu_Divyanshu · June 2, 2021, 7:30am

@saumitra.tiwari
I am not able to understand from where we have to extract the data

saumitra.tiwari · June 2, 2021, 8:56am

Start Time, Status Update, Impact Prior to Resolution. This is present after text “Dear customer”

saumitra.tiwari · June 2, 2021, 9:28am

value1

Topic		Replies	Views
Extracting particular data from email body Help	11	1266	February 7, 2020
Extracting specific info from Email body into excel Studio datatable , excel , mail , studio	1	810	March 12, 2021
How to extract specific data from the mail body Studio studio , question , workflow_diff	16	2267	March 27, 2021
Copy the body of an Outlook Email and paste into an Excel sheet Studio studio , question , tools	11	1080	November 17, 2022
Extract from mail body Activities uiautomation , mail , outlook , activities , studio , regex , uipath , rpa , regex-extractor	20	1462	March 16, 2023

Most Active Users - Yesterday
ashokkarale
Anil_G
gorby
anjasing
adi.mehare
ppr
Speziman
Jon_Smith
Andreea_Nistor
Suzuki_N
More details...

How can i extract specific text from email body?

Related topics