web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Import multiline text ...

Small and medium business | Business Central, N...

Suggested Answer

Import multiline text from Xmlport

(0) Share

Report

Report

Posted on by SYLV1G

55

Dear all,

I try to import data into a multiline text field in a table.

I created an XMLport and the text field is populated but I do not have a CR LF after each line as in my source file

. 8865.File.png

Do you have any idea ?

Thanks in advance

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

Maybe the XML port is not the right tool for this.

I would try to read the file directly into a blob and parse the file directly from the blob.

Was this reply helpful? Yes No
SYLV1G 55 on at

Like (0)

Report

Hello,

Thanks for your reply,

I changed the input file (replace CR and LF by a String [CRLF] because we generated it from another software) and I was able to read the file .

I replaced the string by CR and LF before to write the String in Business Central

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, How about using TextBuilder.AppendLine([Text]) Method.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/textbuilder/textbuilder-appendline-method

A simple case for export.

https://yzhums.com/21942/

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,468

#2

YUN ZHU 923 Super User 2025 Season 2

#3

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans