split a string with multiple values

[jean-pauldehaas]

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 ?

[jean-pauldehaas]

actually there are 2 structures:

organization/EU/organizationname1

and

organization/organizationname1

[Chetan Mahajan · Accepted solution]

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);

[jean-pauldehaas]

thanks Chetan much appreciated!

[jean-pauldehaas]

Hi Chatan,

1 question, sometimes the values coming in from the external system are not exactly the same as in SN.

for example coming in is Euro car parts and in SN its called ECP

[Chetan Mahajan]

If you dont mind could you please provide possible responses so that i can try make script on that.