How to remove extra carriage return on a generated text file in Appian
0085117,000011.55,000011.55CRLF0052514,000035.00,000035.00CRLFCRLF
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###.
nicholaso0002 said: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.