Writing into Multilines fields

[Former Member]

Hello all,

I've a problem in importing data into multiline fields like "free_text" for BusinessPartners (SQL server 2000 : data type : ntext).

How can i délimited differents lines into my data line value ?

thanks for helping me

Julien

[Former Member]

I finally develope a short add on and '\r' works fine.

Thanks all

[rasmuswulff_jensen]

In the sdk both \r and \n works.. I will quess it also works in DTW

Sample:

Line1nLine2nLine3

=

Line1
Line2
Line3

[Former Member]

thanks Rasmus but It does not work when loading free_text of BPA with DTW.

[rasmuswulff_jensen]

Okay... SAP is just stupid here... 😐

As far as I can see they use the ASCII Code 0A as Line Break since this is what ALT+Enter in a Excel Column produce when converted to CSV... In notepad this is show as a little square and if you copy/past this around it works... See SAP note 918536 for more....

SAP should really think about supporting \n in addition...

[bruno_peyron]

> As far as I can see they use the ASCII Code 0A as<br/>

> Line Break

<br/><br/>

ASCII (an Unicode) <tt>0A</tt> <b>is</b> a \n ("LF", "line feed").

<br/><br/>

Default Windoze newlinne is \r\n (<tt>0C 0A</tt>), though.