Unwanted Linefeed characters getting returned in eText output

KDR

I am having an issue where there is both Line Feed and Carriage Return characters (CR LF) between each row of data as shown on the Right side of the below screenshot, when I am only expecting carriage returns to be returned as shown on the left side (until after the end of the ZBL lines where it should be CR LF together).

How can I accomplish this? I have attached an updated eText template for reference. Thank you.

TGC_INT003_ITEMS_INFO_EPIC_NEW_TEMPLATE_FORMAT8-4.docx

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24935/unwanted-linefeed-characters-getting-returned-in-etext-output

Hi KDR,

I think I haven't understood your issue correctly.

" I am only expecting carriage returns to be returned as shown on the left side (until after the end of the ZBL lines where it should be CR LF together)."

So, in the output, I can see new line only after ZBL:

Can you please clarify your requirement?

Thanks.

KDR

@MandeepGupta The CR LF should only occur at the end of the last 'ZBL' line for each record (in cases where there may be more then on 'ZBL' record before starting over at the 'MSH' header record again (for next recordset). The line containing just the CR LF I do NOT want between recordsets I do NOT want. Where as now all the other lines (MSH, MFI, ITM, NTE, ZSU, VND, PKG, IVT) are containing the CR LF after them as shown above which I do NOT want either.

I hope this helps clarify but let me know if you need additional clarification.