Script to extract a number from the mail subject line

nehasr1288 · ‎03-15-2017

Hi,

I need to write a script to extract a number from the subject of the mail.user sends a mail to dev****.servicenow.com.

From System Policy > Email > Inbound Actions I have configured:

and in actions tab I have mentioned the actions when a mail is received:

Now I need to write a script that may take a number from the mail subject and insert it in a custom field.

Alikutty A · ‎03-16-2017

The code you added in the previous screenshot is wrong.

Can you please replace it with this

var rsubject=email.subject;

var keyword="Ticket#: ";

var len = keyword.length;
var key = rsubject.indexOf(keyword); //Assuming this text would never change

if(key > 0){

var number = rsubject.substring(key+len, 7);

gs.log(number, "TEST"); //Try logging number

current.u_ast_id = number;
current.update();

}

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

Dave Smith1 · ‎03-16-2017

Perhaps a regular expression could be what you're after - it can strip out leading/succeeding characters to leave data of interest.