Skip to Content
Former Member
May 28, 2014 at 07:32 AM

.csv file having issues


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 -

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.