Pauline818
New Member
Hi team
im new to blue prism, and im trying to extract a table out of an email from Microsoft outlook.
i have used the action "Get Recieved items (Basic)" and able to extract the email body.
what im trying to do is to extract the text after "Reason-Batch".
i have used formula as per below:
Trim(Right([Email Items.Body],Len([Email Items.Body])-InStr([Email Items.Body],"Reason-Batch")-11))
but this formla is including every text that is after "Reason-Batch". i only want 1 line of data after "Reason-Batch".
how can i do this?
im new to blue prism, and im trying to extract a table out of an email from Microsoft outlook.
i have used the action "Get Recieved items (Basic)" and able to extract the email body.
what im trying to do is to extract the text after "Reason-Batch".
i have used formula as per below:
Trim(Right([Email Items.Body],Len([Email Items.Body])-InStr([Email Items.Body],"Reason-Batch")-11))
but this formla is including every text that is after "Reason-Batch". i only want 1 line of data after "Reason-Batch".
how can i do this?