Level 3

Solved

Export Data with Unix Line Ends

4 replies
2801 views
Translate All

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

A

alistairk161838Accepted solution

Level 3

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

Level 10

Hi Alistair,

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

Regards,

Amit

Translate

A

alistairk161838AuthorAccepted solution

Level 3

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!

Translate

Amit_Kumar

Level 10

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

Translate

A

alistairk161838Author

Level 3

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

Translate

Sign up

Login with SSO

Login to the community

Login with SSO