Sting manipulation from the subject of the mail

Help
1

Hi team,

I want to retrieve subject from specific email and them implement string manipulation in a way that i get 2 kind of data from the subject,

  1. name of the resource
  2. after how many days the contract is expiring.

The sample subject line is as follows:

Action Required: Employee Chethan kumar k contract is getting expired 15 days from today

from this i want

  1. Chethan kumar k
  2. 15
    to be extracted and stored in a variable
    so how to do it?
2

@Aishwarya_Bhargava

Use Matches activity

For Employee name

image
image938Ă—248 7.37 KB

EmployeeStringVariable = Result(0).ToString

For Days

image
image932Ă—265 8.21 KB

DaysStringVariable = Result(0).ToString

mark as solution if this helps you

Thanks

3

how can i convert the number so obtained into double or integer

4

@Aishwarya_Bhargava

cint(result(0).ToString)

Hope this helps

Thanks

1 Like
5

how do i retrieve “Mohammed Ali” from the string “Notification || Last Working Day in UIPL -FTE - Mohammed Ali”

6

@Aishwarya_Bhargava

Check as below

image
image1185Ă—325 8.37 KB

([^-]*)$

Mark as solution if this helps

Thanks

7

thankyou, it worked

1 Like
8

will this expression also be able to get the value “Madhu Jaikumar || Anil Chacko || Syed Hussaini || Puja Batra || Uday kumar Avula || Saji Pallathu Mathai”
from
“Notification || Entity Transfer from UIPL to UINC (ADNOC) || Last Working Day in UIPL - Madhu Jaikumar || Anil Chacko || Syed Hussaini || Puja Batra || Uday kumar Avula || Saji Pallathu Mathai”

9

@Aishwarya_Bhargava

Yes it will work

Thanks

10

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