Question Re: HCI csv converter, remove blank line between headers and elements in Technology Q&A

HCI csv converter, remove blank line between headers and elements

Former Member — Thu, 23 Feb 2017 23:18:59 GMT

I added to the XSLT Mapping file a customize header, example:

<H1>Customize Header</H1>

</Header>

<Value1>Value 1</Value1>

</Elements>

</Records>

But when i use the XML to CSV converter the iflow gives me a .csv file with a blank line between the header (Customize Header) and the elements (Value1).

CSV File output:

Customize Header

------Blank line-----

Value 1

Is there a way to remove the blank line?

Regards,

Re: HCI csv converter, remove blank line between headers and elements

Former Member — Fri, 24 Feb 2017 00:06:55 GMT

I already resolved this issue i put an script after the xml to csv converter with this code:

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

import java.util.HashMap;

def Message processData(Message message) {

def body = message.getBody(String.class);

body = body.replaceAll("[\n]","");

message.setBody(body);

return message;

}

Kind Regards,