Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Export Data with Unix Line Ends

Avatar

Avatar
Validate 1
Level 2
alistairk161838
Level 2

Likes

13 likes

Total Posts

37 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
alistairk161838
Level 2

Likes

13 likes

Total Posts

37 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
alistairk161838
Level 2

06-02-2018

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
alistairk161838
Level 2

Likes

13 likes

Total Posts

37 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
alistairk161838
Level 2

Likes

13 likes

Total Posts

37 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
alistairk161838
Level 2

07-02-2018

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!

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 2
alistairk161838
Level 2

Likes

13 likes

Total Posts

37 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
alistairk161838
Level 2

Likes

13 likes

Total Posts

37 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
alistairk161838
Level 2

07-02-2018

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

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

07-02-2018

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

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

06-02-2018

Hi Alistair,

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

1412190_pastedImage_0.png

Regards,

Amit