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

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