Export Data with Unix Line Ends

[alistairk161838]

I need to export data out in the unix format of only having a line feed at the end of each line rather than the windows format of carriage return + line feed. How would I go about do this?

[Amit_Kumar]

Hi Alistair,

did you try CR/LF option in the in extraction file format? It should work in UNIX.

Regards,

Amit

[alistairk161838 · Accepted solution]

Hi Amit,

So the option you show seemed to export out in the windows format which is CRLF, instead of the required UNIX format which requires only LF. However exporting out simply as CR with Latin encoding seemed to export out with only a LF end character (which seems odd but it is Adobe Campaign after all).

The best solution for me was to export out as UTF-8 encoding with the CR line end as this fulfilled two use cases I needed to satisfy. Thanks for the response!

[Amit_Kumar]

Hi Alistair,

I did a bit of research about the end of line chars, I didn't test my solution with UTF-8 or latin encoding though but as per this ticket in StackOverflow it should work with both system with CRLF option as CR is supported in windows and LF in Unix so as per definition CRLF should translate to a system agnostics solution. Did you test CRLF and None with UTF-8 in both systems?

Difference between CR LF, LF, and CR line break types? - Stack Overflow

Glad you found your solution.

Regards,

Amit

[alistairk161838]

Hi Amit,

I didn't delve too far into the details other than fulfilling the use case requirements which was asking for exported files to have UTF-8 encoding with the UNIX LF line ending required for import into another tool. In practicality it probably makes little to no difference

Cheers

Alistair