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.