Export Customers as a CSV file using Codeunit or Report

I hate to say.. 😁
Tomorrow you'll have an example. If no one beats me to it.

Hello @Jacob1227 ,

If you really want to use a report, you could use a "File" variable, but make sure you are not putting it on the server.

OnPreDataItem()
IF NOT FILE.EXISTS(<Your FileName>) THEN
FILE.ERASE(<Your FileName>);

fileExport.CREATE(<Your FileName>);
fileExport.TEXTMODE := TRUE;
fileExport.WRITEMODE := TRUE;

OnAfterGetRecord()
fileExport.WRITE(STRSUBSTNO('%1;%2;%3;%4;..",
<Your Values>);

OnPostDataItem()
fileExport.CLOSE;

And you gonna do things like add quotation marks and escape already existing quotation marks? In a more modern version like 17 or 18, one can use the CSV Buffer table. Unfortunately I have a similar problem in NAV2015, so I will probably backmigrate half of the functionality of the CSV Buffer...

Do you want to include a header in a csv file?

OnPreDataItem()
IF FILE.EXISTS(<Your FileName>) THEN
FILE.ERASE(<Your FileName>);

fileExport.CREATE(<Your FileName>);
fileExport.TEXTMODE := TRUE;
fileExport.WRITEMODE := TRUE;
fileExport.WRITE(STRSUBSTNO('%1;%2;%3;%4;..",
<Your Header Values>);

OnAfterGetRecord()
fileExport.WRITE(STRSUBSTNO('%1;%2;%3;%4;..",
DELCHR(<Your Values>),'=',STRSUBSTNO('";');

OnPostDataItem()
fileExport.CLOSE;

Please post all lines of code as text, I Will correct them