Question Re: SAP CPI - Groovy script to split a string and make an array list in Technology Q&A

SAP CPI - Groovy script to split a string and make an array list

veenagayathri — Fri, 10 Feb 2023 05:49:51 GMT

Hi guys,

I am writing the below code to split the string(separated by comma) into a list array.

I am giving multiple values to "source value" in content modifier.

mycontentmodifier.png

Code:

import com.sap.gateway.ip.core.customdev.util.Message;

import java.util.HashMap;

import java.util.regex.*;

import groovy.xml.*;

def Message processData(Message message) {

def headers = message.getHeaders();

def rows;

def properties = message.getProperties();

def credentials = properties.get("UserList");

List<String> myList = Arrays.asList(credentials.split(","));

for(i=0;i < myList.size();i++)

{

rows = rows + (myList[i]+"\n");

}

// rows = rows.replace("null","");

message.setBody(rows)

return message;

}

But when I run this, I was able to get the below output.

Output:myoutput.png

I am getting a null at the beginning, I can simply replace it. I also tries to assign null value to my variable"rows". But still I am getting the same output. I want to know what is wrong with my groovy code.

Thank you!

Re: SAP CPI - Groovy script to split a string and make an array list

akmal1216 — Fri, 10 Feb 2023 06:40:22 GMT

Hello Veena,

Since you already created List, you can check and remove null values first, then continue with your logic.

list.removeAll([null])

Best regards,

Akmal

Re: SAP CPI - Groovy script to split a string and make an array list

asutoshmaharana2326 — Fri, 10 Feb 2023 14:07:33 GMT

Dear Veena,

This issue can be fixed by various ways. I would say just define rows as "" while initializing.

import com.sap.gateway.ip.core.customdev.util.Message;

import java.util.HashMap;

import java.util.regex.*;

import groovy.xml.*;

def Message processData(Message message) {

def headers = message.getHeaders();

def rows = "";

def properties = message.getProperties();

def credentials = properties.get("UserList");

List<String> myList = Arrays.asList(credentials.split(","));

for(i=0;i < myList.size();i++)

{

rows = rows + (myList[i]+"\n");

}

// rows = rows.replace("null","");

message.setBody(rows)

return message;

}

Re: SAP CPI - Groovy script to split a string and make an array list

veenagayathri — Mon, 06 Mar 2023 14:33:49 GMT

Hi,

Yes. It worked. I should define "" to my variable. It is just my mistake!

Thank you so much.

Regards,

Veena