on 03-22-2011 9:07 AM
How can I get below CSV file from below XML structure using file content conversion in receiver file adapter:
<?xml version="1.0" encoding="UTF-8" ?>
- <MT_Test xmlns:ns0="http://temp">
<EmpID>101</EmpID>
<EmpName>Raghu</EmpName>
<EmpPhone>989898</EmpPhone>
</MT_Test>
Target File format:
101,Raghu,989898
I don't want to create any new structure below MT_Test. I don't want to modify my target structure. From the above given structure, I want to generate target file in below format:
101,Raghu,989898
Thanks,
Adi
Hi Adi,
Ref: http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/frameset.htm
/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion
Content conversion parameters that can be used for your requirement is :
Here I am referring XML as node.
XML.fieldNames:EmpID,EmpName,EmpPhone
XML.fixedFieldLengths:x,y,z (If you would like to fix the lengths of the fields.
XML.fieldSeparator: ,
XML.endSeparator: nl
Thanks,
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.