Extracting certain text from an email

Help StudioX
,
1

Hello,

I am new to UiPath, I’m trying to figure out how do I extract certain text from an email into an excel sheet. I would just like to extract the Date of the email, phone number “9999 9999” and Total Paid, which are all underline in red. Image as attached.

email
email1023×830 16.2 KB

I have also attached my flowchart below to show what I’ve done so far. I’m not finding what I need in the Expression Editor. What should I do? Is regex needed for this task? If possible, I would love to have a template to learn and understand it better.

workflow
workflow393×657 19.8 KB

2

Use Pattern Recognition regular expression using matching pattern activity

3

@DerpyVenom,

If the email format going to be same you can use RegEx else you will have to add multiple regex to get data from each unique mails.

Thanks,
Ashok :slight_smile:

4

Hello

Can you please provide a sample of the email text?

Cheers

Steve

5

Hello,

i have attached an email sample below. i would only be extracting the Date of the email, Phone Number, and Total Paid. all of which is underline in red. the emails received would always be the exact same.

sample