SAP CPI Sender File Adapter unable to convert unicode encoded csv file into readable format

[former_member597936]

The batch file is encoded in unicode and HCI unable to convert the csv file into XML format.
Below is the payload file export on CPI. Is there any way to convert the file format to a readable format before "CSV to XML converter"? Thank you.

[sanjali07]

Hello,

Could you let us know what the error is when converting from CSV to XML?

Regards

Sanjali

[former_member602661]

you could try to plug this code in groovy

String str = body.split(" ")[0];
str = str.replace("\\","");
String[] arr = str.split("u");
String text = "";
for(int i = 1; i < arr.length; i++){
    int hexVal = Integer.parseInt(arr[i], 16);
    text += (char)hexVal;
}