Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Publisher Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unwanted Linefeed characters getting returned in eText output

Received Response
11
Views
2
Comments
KDR
KDR Rank 4 - Community Specialist
in Oracle Analytics Publisher Forum

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).

image.png

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
Tagged:

Answers

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics & AI Strategist
    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:

    image.png

    Can you please clarify your requirement?

    Thanks.

  • KDR
    KDR Rank 4 - Community Specialist

    @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.