How to extract Delivery order number?

Hi
How to extract DO number using string maupulation method

  1. extract subject
    2)Extract DO number
    image

Regards
Priyanka

Hi @Priyanka_Jadhav1

Try to follow the below steps
Use Get Outlook Mail activity to get the mails from Outlook.

  • Then from the GetOutlook Mail Activity output List you can loop
  • Assign item.Body to a string variable
  • Extract the specific text using regex/substring then assign it to the variable.

Regards
Gokul

Hi @Gokul001
how to extract specific text, unable to find. please help me to create expression

regards
Priyanka

@Priyanka_Jadhav1

  1. First read the email body from the email and assign it to one string variable. Let’s say EmailBody.

  2. And then try below expression to fetch delivery order number.

       DONumber = EmailBody.SubString(EmailBody.IndexOf("Delivery order number: ")+"Delivery order number: ".Length). Split(Environment.NewLine.ToCharArray)(0).Trim

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