Dear experts,
I have the following XML structure
<DT_SALES_REPORT_JDE_CA>
<list>
<RecordsetA>
<a>
<b>
</RecordsetA>
<RecordsetB>
<a>
<b>
<c>
</RecordsetB>
<a>
<b>
<c>
<RecordsetB>
</RecordsetB>
</list>
</DT_SALES_REPORT_JDE_CA>
and I am using CC in the receiver file adapter:
RecordsetA.fieldSeparator ","
RecordsetB.fieldSeparator ","
RecordsetA.endSeparator "\n
RecordsetB.endSeparator "\n
RecordsetA.beginSeparator "
RecordsetB.beginSeparator "
which gives me this structure:
"a","b"
"a","b","c"
"a","b","c"
This is fine the only issue I have is that at the very end it also gives me a line feed of course.
But I have to get rid of that last line feed!
But how can I achieve that? Is that possible at all?
I cannot use ".fixedLength" because the fields have variable lenghts.
Thank you for any ideas and best regards,
Peter