on 03-19-2010 7:55 AM
hi All,
I am trying to convert an XML file to CSV using AF_Modules/MessageTransformBean module key XML2Plain in the Communication channel.
http://help.sap.com/saphelp_nw04/Helpdata/EN/24/4cad3baabd4737bab64d0201bc0c6c/content.htm
My Structure looks like
<resultset> -- 1
<row> -- 0 .. *
<line>ABC</line> -- 1
</row>
</resultset>
Length of line is not fixed.
XML2Plain Transform.Class com.sap.aii.messaging.adapter.Conversion
XML2Plain Transform.ContentType text/plain;charset=utf-8
XML2Plain xml.conversionType SimpleXML2Plain
XML2Plain xml.addHeaderLine 0
Now what should be value of endSeparator or field separator if length is not fixed?
If sample input is:
<resultset>
<row>
<line>ABC</line>
</row>
<row>
<line>sapnetweaver</line>
</row>
</resultset>
Output should be:
ABC
sapnetweaver
Please help!
Thanks,
Mayank
Hi,
As mentioned output want is CSV then need to define the separator as comma...for field and end separator as newline..
thats it...
HTH
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.