Skip to Content

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

Complex CSV file reading

Hi Experts,

I am trying to read a csv file in zip.So I used File adapter module "PayloadZipBean" to unzip and read csv with MTB(Message Transform Bean) and its working fine.

Now I am getting error in case if my file has multi lines for a field value.

Eg::  

field1,field2,field3,filed4

"val1","val2","val3and

desription of line details","val4"

MTB parameters are : is it possible to read multi line values of single field with MTB ,if not what is other best alternate simple approach.

Please let me know the approach not just links as I cant understand the way to go ahead.

zip.modeunzip
Transform.Classcom.sap.aii.messaging.adapter.Conversion
Transform.ContentTypetext/xml;charset=utf-8
xml.conversionTypeSimplePlain2XML
xml.documentNameMT_test_SND
xml.documentNamespacehttp:\\xyz
xml.documentNamespaceScoperoot
xml.enclosureConversionNO
xml.enclosureSign"
xml.encodingUTF-8
xml.endSeparator"'nl'
xml.fieldNames
f1,f2,f3,f4...f10
xml.fieldSeparator,
xml.processFieldNamesfromConfiguration
xml.structureTitleRow

Regards

Siri

replied

Siri,

1. I have updated the blog to handle comma, please check it.

2. Yes UDF will be same. Please update it according to target structure.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question