Finding text in emails - inbound email actions

[brycefraser]

I am trying to create an inbound email action that takes our Separation Notification emails, finds the user name within the email, and then uses that to automatically disable the AD account associated.

The emails look something like this:

Good morning all,

Please be advised that the following employee has finished at St Andrews War Memorial Hospital.

Name:

John Smith

Employee No:

000000

Position:

Employee

The problem I am having is trying to pull the name from the email, currently I am trying to do so using email.body_text.indexof, e.g.;

var pos1 = email.body.indexof("Name:");

var pos2 = email.body.indexof("Employee No:");

var name = email.body.substring((pos1 + 1), (pos2 - 14));

Ideally this should set the variable "name" to whatever is between the Name: line and the "Employee No:" line.

When the code runs, however, all that returns for pos1, pos2 and name is "undefined". I can't seem to work out what is wrong.

Any help with this would be great.

Thanks!

[brycefraser]

Hi Ganesh

Thanks for the tip, i've given this a try and it does work when the name is on the same line as the label, e.g. Name: John Smith

I'll have to contact our HR team to see if they're able to change the email slightly.

Thanks again