How to handle line breaks in text field during export?

(1) Share

Report

Posted on by BD-25111452-0

Hi,

I have a table in BC with multi line text fields. When displaying the field on a page, line breaks are displayed normally. But now I would like to export the data for use in Excel. When I create the Query and use the Odata connection in Excel, the text is shown as a single line of text.

I am new to BC and AL so I was hoping somebody could give pointers on how to get the data to Excel including the line breaks.

Thank you in advance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

YUN ZHU 96,041 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, Hopefully the following content can give you some hints.

Dynamics 365 Business Central: How to set multi-line text for a Blob Data Type field via AL

https://yzhums.com/38800/

Thanks

ZHU

Was this reply helpful? Yes No