Skip to Content
0
Former Member
Apr 08, 2014 at 11:03 PM

Importing text fields with newlines in DTW

457 Views

How do you get the DTW to let you import strings with newlines in? Currently using TSV...

suggests to use "
 
", but upon testing, into a user defined text field, it is still "
 
" when imported and viewed inside B1. I note said article is from 2005...

Literal newlines get taken as being new rows/record in the input file. Quoting strings seems to make no difference.

If I amend the string via SAP B1 to add a newline, it's stored in the database as a literal newline. Copying to Notepad++ shows it as expected too

\r\n doesn't work either

Thanks!