bi-publisher

eText template inserting Carriage Return and Linefeeds, want only Carriage Returns used

I have an eText template I use with Oracle BIP / Fusion ERP that outputs a .txt file and for reason the output file is adding in Carriage Return (CR) and Linefeed (LF) characters on each row or data as seen below:

enter image description here

What I need is to only have Carriage Returns between each line, and only have the CR LF (both) appear after each iteration of the loop (after each ZBL row). How can I accomplish this? Link to the eText template:

eText Template: https://docs.google.com/document/d/1pmiqBCSy6JEnXmvPqhl2v7wfelRrrTFa/edit?usp=sharing&ouid=103584679315291016426&rtpof=true&sd=true

XML Source data: https://drive.google.com/file/d/1Tslxo5N2pOBgSPyk-yu6gYG7daS2TUmg/view?usp=sharing

Screenshot of template (in case you can not open the link):

enter image description here

Solution

  • Remove the <NEW RECORD CHARACTER> so that it is [NULL], meaning no data is present in that parameter.

    You have some other things that the Oracle Template Viewer doesn't like. Need to merge some cells.

    enter image description here

    Add additional Alpha Chr(13) records if you need additional lines between sections.

    enter image description here

    I got output:

    enter image description here