17
Currently when using the CSV Buffer to export data to a csv, the WriteToStream procedure expects all lines in the buffer to have the same number of columns.
The Idea would be to check the number of columns for each row before writing the contents of the CSVBuffer to the StreamWriter. This could be stored in a dictionary and then checked before deciding if a FileSeparator is to be added or new line taken.
For OnPrem sites we have written bespoke code on the table extension to get around this issue but as the StreamWriter DotNet variable cannot be accessed when using Cloud, a solution is needed in the Base App.
STATUS DETAILS
Needs Votes

Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team