Skip to Content

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

Help needed in FILE CC

Hi All,

I am trying to convert XML to CSV(Content conversion in Receiver File adapter).

1. Here is the XML

<?xml version="1.0" encoding="UTF-8"?>

<ns0:Emp_MT xmlns:ns0="http://sdn.com/XML_TO_CSV_01">

-


<Record>

-


<Name>David</Name>

-


<Sal>100</Sal>

-


</Record>

-


<Record>

-


<Name>Michal</Name>

-


<Sal>200</Sal>

-


</Record>

-


<Trailer>

-


<Flag>END_END</Flag>

-


</Trailer>

</ns0:Emp_MT>

2. My output need to be

David|100|

Michal|200|

END_END|

3.Content conversion

Recordset Structure = Record,*,Trailer,1

Record.endSeparator |

Record.fieldSeparator |

Trailer.endSeparator |

Trailer.fieldSeparator |

Record.addHeaderLine 0

I know I am doing wrong with CC. I went through the blog, but could not able to fix it. Can any one help me in fixing it.

Thank you

Ganges Leaves

Former Member
Former Member replied

Hi,

3.Content conversion

Recordset Structure = Record,*,Trailer,1

Change this to:

Recordset Structure = Record,Trailer

Regards

Vijaya

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