Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

File Content Conversion---> Removing Quotations from csv file

I have a csv file in the folowing format:

field1,field2,field3,field4

"111","222","333","444"

"aaa","bbb","ccc","ddd"

Suppose the header name is row in IR.

While configuring the sender file adapter in XI, i have given following parameters under file content conversion.

row.fieldNames=field1,field2,field3,field4

row.fieldSeparator=","

row.processFieldNames=fromConfiguration

row.beginSeparator="

After picking up the XML file XI processes the data so that we have out put as

row

field1 111

field2 222

field3 333

field4 444"

row

row

field1 aaa

field2 bbb

field3 ccc

field4 ddd"

row

My Problem is what parameter should I add in ID to remove this last quote say 444" and ddd" from the XML message ????

I tried using

row.endSeparator=" but it is still giving the same output.

Can anyone help ????????????????????????

Former Member
Not what you were looking for? View more on this topic or Ask a question