How can I force SFTP upload files to use Windows CRLF line endings instead of Unix LF?

How To
, ,
1

workflow
workflow1508×558 62.7 KB

Hi everyone,

I’m working on an automation that generates a flatfile using the Text Aggregator module. The content comes from Google Sheets and is assembled line by line.

When I upload this file via the SFTP module, the file always ends up using Unix line endings (LF). Unfortunately, the receiving system can only process files if they use Windows line endings (CRLF).

I’ve tried:

  • Setting the row separator in the Text Aggregator to {{carriagereturn}}{{newline}}
  • Using \r\n literal in the “Other” separator option
  • Replacing \n with \r\n using the Text Parser replace

But in all cases, when I inspect the resulting file, the line endings remain LF or is pasting all lines behind eachother.

How can I force the file uploaded via SFTP to be encoded with Windows CRLF line endings?

Any tips, suggestions, or workarounds would be greatly appreciated!

Thank you very much in advance.