Transform map script for glidelist field

madanm7786
Mega Guru

Hi All,

I need to load the data from excel into glidelist field. Data in excel sheet is having multiple users(email id) with semicolon(;) and semicolon and space(; ) seperated.

I have written a transform map script. But it is not working.

Below is the piece of code used for spliting, but with no luck.

var typ= source.u_approval.toString().split(';'); //semicolon seperated

var man = typ.toString().split('; '); //semicolon and space seperated

var gr= [];

  var tp = new GlideRecord('sys_user');

  for(var i=0;i<man.length;i++){

  tp.initialize();

...............

..............

value is not loading into glidelist field.

Please help me on this.

Thanks,

Maddy