split a string with multiple values

jean-pauldehaas · ‎04-03-2023

Hi,

i need to add a field map to map organizations from an external system.

the information that is coming in from the external system is like this " organization/EU/organizationname" i need to map the organizationname part to an existing field in SN.

i know i need to use the split in the source script but i need help on how to do this ?

Chetan Mahajan · ‎04-03-2023

You can use as below then

var str = "organization/EU/organizationName";
var organizationName;
var arr = str.split("/");
if(!(arr[2] == "" || arr[2] == undefined || arr[2] == null)){
organizationName = arr[2];
}
else
{
organizationName = arr[1];
}
gs.info("Organization Name: " + organizationName);

View solution in original post

Ankur Bawiskar · ‎04-03-2023

@jean-pauldehaas

if the structure is changed you need to change the script as well in future

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader