Skip to Content

File Channle with Content Conversion

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 07 at 09:04 AM
    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06 at 03:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded