How to remove extra carriage return on a generated text file in Appian

How to remove extra carriage return on a generated text file in Appian

0085117,000011.55,000011.55CRLF
0052514,000035.00,000035.00CRLF
CRLF

  Discussion posts and replies are publicly visible

  • I may have misread different process vs different nodes within the process, I would verify all scenarios such as - are all 3 inputs always used (assuming no since you have blanks), does the line break issue occur for every process or only where ###trailer### and/or ###line### are blank, etc.  If you need to remove blanks for different scenarios, you could utilize a few different templates OR combine your expressions from those other nodes into 1 along where you add the ###header###.

  • 0
    Certified Lead Developer
    in reply to nicholaso0002
    Looking at the node, I found that only the header is user from the template for that file

    This will be the cause of your extra carriage return(s), given that the first two lines in the template (as evidenced in your screenshot earlier) have hardcoded carriage returns at the ends of the rows, which will be unaffected by the Appian generation.  You will need to migrate to a different template for this process, preferably one where your template file only contains the replacement field(s) needed.