- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-10-2022 01:04 AM
Hi All,
I was getting manager values into array format from catalog variables
For Ex:
a9fd3acf1b832010165320ebbc4bcb26,a9fd3acf1b832010165320ebbc4bcb26,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,485a38926f86c20076eca9331c3ee48f,b21fe4060f67b500059d7d4ce1050ea8,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,f01af4926f86c20076eca9331c3ee440,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,ccfbac83dbfb509018490ad4e2961942,d78e20060f67b500059d7d4ce1050ec1,dd9e60060f67b500059d7d4ce1050e93,0d8070f8dbfeb810631a3ed4e296199d,7cdfcc641bd0ac9000fd33f8cd4bcb37,4720b4460f67b500059d7d4ce1050e1a,139838abdb473c10cc19c3af29961915,3295cd7d0f9c47c0059d7d4ce1050e72,b21fe4060f67b500059d7d4ce1050ea8,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,9366780a0f67b500059d7d4ce1050e8c,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,e166780a0f67b500059d7d4ce1050e55,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,d0874b191b3fa450165320ebbc4bcb0a,438e04201bd0ac9000fd33f8cd4bcb31,bb66ce9b0f47b100059d7d4ce1050e5a,02fa70566f90920076eca9331c3ee488
From the above array string i want only unique values & count of each value duplicate
can anyone help me on this.
Thanks,
Naveen
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-10-2022 01:15 AM
Hi,
then use this
Script:
var str = 'a9fd3acf1b832010165320ebbc4bcb26,a9fd3acf1b832010165320ebbc4bcb26,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,485a38926f86c20076eca9331c3ee48f,b21fe4060f67b500059d7d4ce1050ea8,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,f01af4926f86c20076eca9331c3ee440,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,ccfbac83dbfb509018490ad4e2961942,d78e20060f67b500059d7d4ce1050ec1,dd9e60060f67b500059d7d4ce1050e93,0d8070f8dbfeb810631a3ed4e296199d,7cdfcc641bd0ac9000fd33f8cd4bcb37,4720b4460f67b500059d7d4ce1050e1a,139838abdb473c10cc19c3af29961915,3295cd7d0f9c47c0059d7d4ce1050e72,b21fe4060f67b500059d7d4ce1050ea8,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,9366780a0f67b500059d7d4ce1050e8c,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,e166780a0f67b500059d7d4ce1050e55,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,d0874b191b3fa450165320ebbc4bcb0a,438e04201bd0ac9000fd33f8cd4bcb31,bb66ce9b0f47b100059d7d4ce1050e5a,02fa70566f90920076eca9331c3ee488';
var arr = str.split(',');
var count = {};
arr.forEach(function(i) { count[i] = (count[i]||0) + 1;});
for (var key in count){
gs.info(key + ": " + count[key]);
}
Output:
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-10-2022 01:10 AM
Hi,
your requirement is to get unique or count of each value which is duplicate?
you can use ArrayUtil unique method to get unique
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-10-2022 01:12 AM
Hi Ankur,
I want count of individual manager from array list.
Regards,
Naveen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-10-2022 01:15 AM
Hi,
then use this
Script:
var str = 'a9fd3acf1b832010165320ebbc4bcb26,a9fd3acf1b832010165320ebbc4bcb26,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,485a38926f86c20076eca9331c3ee48f,b21fe4060f67b500059d7d4ce1050ea8,c9c841250f6c8240059d7d4ce1050e63,c9c841250f6c8240059d7d4ce1050e63,f01af4926f86c20076eca9331c3ee440,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,ccfbac83dbfb509018490ad4e2961942,d78e20060f67b500059d7d4ce1050ec1,dd9e60060f67b500059d7d4ce1050e93,0d8070f8dbfeb810631a3ed4e296199d,7cdfcc641bd0ac9000fd33f8cd4bcb37,4720b4460f67b500059d7d4ce1050e1a,139838abdb473c10cc19c3af29961915,3295cd7d0f9c47c0059d7d4ce1050e72,b21fe4060f67b500059d7d4ce1050ea8,dd9e60060f67b500059d7d4ce1050e93,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,9366780a0f67b500059d7d4ce1050e8c,c9c841250f6c8240059d7d4ce1050e63,dd9e60060f67b500059d7d4ce1050e93,e166780a0f67b500059d7d4ce1050e55,c9c841250f6c8240059d7d4ce1050e63,a9fd3acf1b832010165320ebbc4bcb26,d0874b191b3fa450165320ebbc4bcb0a,438e04201bd0ac9000fd33f8cd4bcb31,bb66ce9b0f47b100059d7d4ce1050e5a,02fa70566f90920076eca9331c3ee488';
var arr = str.split(',');
var count = {};
arr.forEach(function(i) { count[i] = (count[i]||0) + 1;});
for (var key in count){
gs.info(key + ": " + count[key]);
}
Output:
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-25-2022 08:21 AM
I'm here to look for a solution to my website's issue. So, thank you to everyone in the community for their assistance.