Skip to Content
0
Jun 07, 2011 at 08:12 AM

FCC in receiver channel - get rid of last line feed?

40 Views

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