Get the output in below format

[Ankita9793]

Hi all,

How can i get the output in below format, please suggest

expected outcome : (19646)ahmed.moh@gmail.co.in / (46789)sudars.awar@gmail.co.in

widget_Ankita>>> 19646, ahmed.moh@gmail.co.in, 46789, sudars.awar@gmail.co.in

var delname = 'Moh Ahmed, Sudars awar';

var delnew = delname.split(',').map(function(item) {

    return item.trim();

});

// var del_name = delname.trim();

// var delnew = del_name.split(',');

var delarray = [];

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

    var getdel = new GlideRecord('sys_user');

    getdel.addQuery('name', delnew[i]);

    getdel.query();

    if (getdel.next()) {

        delarray.push(getdel.employee_number + '');

        delarray.push(getdel.email + '');

    }

}

var delempid = delarray;

gs.print('widget_Ankita>>> ' + delarray);

gs.print('del_name>>> ' + delnew);

[Ankur Bawiskar · Accepted solution]

@Ankita9793 

try this

var delname = 'Moh Ahmed, Sudars awar';
var delnew = delname.split(',').map(function(item) {
    return item.trim();
});

var result = [];
for (var i = 0; i < delnew.length; i++) {
    var gr = new GlideRecord('sys_user');
    gr.addQuery('name', delnew[i]);
    gr.query();
    if (gr.next()) {
        result.push('(' + gr.employee_number + ')[' + gr.email + ']');
    }
}

var output = result.join(' / '); // Main output
gs.info(output); // Example: (19646)[ahmed.moh@gmail.co.in] / (46789)[sudars.awar@gmail.co.in]

If my response helped please mark it correct and close the thread so that it benefits future readers.

[KrishnaMohan]

Hi @Ankita9793 

Try below one

var delarray = [];
for (var i = 0; i < delnew.length; i++) {
    var getdel = new GlideRecord('sys_user');
    getdel.addQuery('name', delnew[i]);
    getdel.query();
    if (getdel.next()) {
        delarray.push("("+getdel.employee_number +")"+getdel.email );
    }
}
var delempid = delarray.join("/");

 
If this helped to answer your query, please mark it helpful & accept the solution.

Regards,
Krishnamohan

[Bhuvan]

@Ankita9793 

Below is a sample from PDI, reuse to your requirement

var delname = 'ACME Japan, ACME France';
var delnew = delname.split(',').map(function(item) {
    return item.trim();
});
var delarray = [];
for (var i = 0; i < delnew.length; i++) {
    var getdel = new GlideRecord('sys_user');
    getdel.addQuery('name', delnew[i]);
    getdel.query();
    if (getdel.next()) {
        delarray.push(getdel.employee_number + '');
        delarray.push(getdel.email + '');
    }
}
var delempid = delarray;
var input = delarray.toString().split(",");
const output = `(${input [0]})${input [1]} / (${input [2]})${input [3]}`;
gs.print('Array is ' + delarray);
gs.print('Name is ' + delnew);
gs.print(output);

 

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@Ankita9793 

Did you get a chance to review this ?

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan