File Channle with Content Conversion

[davidschievers]

Hello all,

I am thinking for a solution for the following task:

We are creating a .csv file with the File channel and using Content Conversion. That is working fine but we are having a columm where we enter a long text. Now we would like to have this text with a line break in this columm. To be honest I do not think this possible but maybe someone can advise.

Here are a example how it looks right now:

STXT_MATNR STXT_VKORG STXT_VTWEG STXT_SPRAS STXT_TEXT Example 1 1 S Exampeltext which should have line break

Regards
David

[JaySchwendemann · Accepted solution]

Three solutions I could think of:

1. use double quotes for your column in question. This should go roughly in line with RFC 4180 Section 2.6. However, it all boils down to the receiver accepting this
2. Use escaping, e.g. %x0D%x0A or CR LF, also something that the receiver must accept
3. Use a structured CSV approach where all the columns except the longtext build the header line and each of the longtexts lines will be a item line

Cheers

Jens

[davidschievers · Accepted solution]

Thank you.

[JaySchwendemann · Accepted solution]

How did you (plan to) tackle to problem ultimately?

Cheers

Jens

[isuru_fernando24]

Hi David,

I handle complex content conversions only using the B2B Integration cockpit. It has more capabilities to handle complex conversions. If you need more information on how to use B2B Integration Cockpit for content conversions check this blog post.

Cheers!

Isuru

[davidschievers]

Thank you.