.csv file having issues

47 Views

Hi folks,

I have a proxy to file(SFTP) interface.

I need to generate a .csv file. I am using the module localejbs/AF_Modules/MessageTransformBean.

Parameters: Transform.Class - com.sap.aii.messaging.adapter.Conversion

Transform.ContentType - text/plain;charset=utf-8

xml.addHeaderLine - 1

xml.conversionType - SimpleXML2Plain

xml.endSeparator - 'nl'

xml.fieldSeparator - ,

xml.recordsetStructure - Header,Record

.csv file is generating but in case if the data in the single field has commas like address field has Room 100, Estates LA, Fanyu

then in the file instead of coming in the single field address comes in three different fields and due to this the whole record moves forward.

Kindly guide on the same which step to include.

Currently I have convered , to - in the mapping by writing a UDF. But this is a temporary solution as I am manipulating the data.