Skip to main content
Solved

Import stock item description with line breaks

  • 25 July 2024
  • 1 reply
  • 47 views

Hey everybody,
Is there a possibility to import the description of stock items via Excel with line breaks? It seems that the import scenario doesn’t take the line breaks from excel into account…

 

Any help is greatly appreciated! :)

 

Hi @manuelschulze ,

I’ve had success pulling in line breaks using CHAR(13) & CHAR(10).  First use the Excel find and replace to replace all of line breaks on the spreadsheet with a special string such as #@$.  Then add a new column with a formula to substitute #@$ with CHAR(13) & CHAR(10)

=SUBSTITUTE(B2, "#@$", CHAR(13) & CHAR(10))

We used this as the data source for an import scenario to import PO line notes.

Hope this helps!

Laura

Reply


Terms & ConditionsCookie settings