Filter email body on specific line

Help Activities
,
1

I want to extract the ticket reference number from this email. How do I filter the email body

image
image790Ă—206 4.01 KB

2

Hi @Tengku_Aliff
Are you able to get email body through mail message right?

3

Hi @Tengku_Aliff, welcome to the Community.

You can simple read the email body & use the following RegEx pattern to extract the desired data:

Ticket ref: (\w+\d+)

image
image1169Ă—481 59.2 KB

The corresponding UiPath Syntax will be:

System.Text.RegularExpressions.Regex.Match(emailBodyString,”Ticket ref: (\w+\d+)”).ToString

Hope this helps,
Best Regards.emphasized text

1 Like
4

yes i am able to do just that. its the filtering function that i am having trouble with

5

thats great thank you! i will try and use regex for the filtering.

btw, is there any other method other than using regex? like in power automate you can use method like split, trim and skip in filtering. i wonder if you can use it in UiPath

6

Hi @Tengku_Aliff

  1. Use get outlook mail messages and read the email with the subject you have and want to read.
  2. Use For each activity and save the mail body in txt document.
  3. Read the text file and use find Matching Patterns activity and use regular expression to get ticket ref no as below:
(?<=[A-Za-z]:\s)(.*)

image
image1430Ă—506 17.4 KB

4. save the output and use for each activity and print using an log message. If you have further process you can perform that.
Note: Attached the entire workflow for reference. Attached both Regex process and split method process in the same zip file. Please Check.
Email.zip (157.7 KB)

Hope it helps!!
Regards,

1 Like
7

@Tengku_Aliff

If there are no content present after Ticket ref: SRF0003779795, you can simply manipulate the string & use the following function:

emailBodyString.Split(“Ticket ref: ”)(1).ToString.Trim

This will split the string based on Ticket ref: keyword & return the SRF0003779795 part as the output.

Hope this helps,
Best Regards.

1 Like
8

@Tengku_Aliff

If you find solution for the query mark it and close the loop

Regards,

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.