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

CSVBuffer with different number of columns per line

(5) Share

Report

Posted on by PaulJ94

When using the CSVBuffer to export data, the below code expects each line to have the same number of columns.

This is not always the case when writing a CSV. Has anyone had to create a workaround for this? Or should it be submitted as a bug to Microsoft?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Khushbu Rajvi. 20,647 Super User 2025 Season 2 on at

Like (3)

Report

Not sure but check this if helps: https://www.youtube.com/watch?v=cp91N4xFqlg

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

The issue you're facing with the CSVBuffer expecting each line to have the same number of columns can be addressed by either pre-processing the data to ensure uniform column counts or implementing a custom CSV writer that handles varying column numbers. If these solutions don't work, consider submitting it as a bug to Microsoft for a more flexible CSVBuffer.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,247 Super User 2025 Season 2 on at

Like (1)

Report

You should always have same number of columns for each row, if you don't have the data in the a specific column you still need to send blank empty.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, Try TextBuilder Data Type, you can change the number of columns at will, just add some conditions.

How to export data from tables to CSV (comma-separated values) file -> Using TextBuilder Data Type

https://yzhums.com/38484/#toc2

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,373 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Handle any CSV file with the CSV Buffer in AL and Business Central

csv buffer in business central | import csv file to business central | business central tutorial

Best Regards
Gerardo

Was this reply helpful? Yes No