Creating CSV file through code using streamwriter

(0) Share

Report

Posted on by Wekey

302

Hello All,

I have created a logic to create a CSV file through code using streamwriter by addling values to the list and using strList2str(List, ',') I have used ',' as the delimiter. I am fetching records form the table and creating this CSV file and it is working fine except for few fields because of the field value(for eg: Address field - california, USA). This field is getting split because it has a , value.

Is there any workaround to achieve this?

Thanks

I have the same question (0)

All responses (18)

Answers (1)

Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Wekey,

Are you able to use another delimiter or quotes around the Address field? With quotes it should know the comma is part of the field value instead of a separator.

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Wekey,

I agree. You can try to use other delimiter , provide it as a parameter.

Such as strList2Str(list, ';').

You can find existing examples:

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report
strList2str() won't indeed give you valid X , because it doesn't add quotation marks around strings such as addresses.

I would use CommaTextStreamIo. For example:

CommaTextStreamIo io = CommaTextStreamIo::constructForWrite(); io.writeExp(['Joe', 'California, USA']); File::SendFileToUser(io.getStream(), 'file.csv');

Was this reply helpful? Yes No
Wekey 302 on at

Like (0)

Report

Hello Andre,

Thanks for your reply.

I am using List(string) and also adding values using list.addend() so by default the values are between quotes.

for eg:

value 1:"california, USA"

Value 2:"someValue"

Regarding deLimiter I am using ',' because default delimiter for csv is ','.

Please suggest if there is anything I can change here.

Thanks

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

HI Wekey,

In my region, the default CSV separator is commonly a semicolon. Also a pipe is used a lot. This all prevents issues with a comma in the text.

Was this reply helpful? Yes No
Wekey 302 on at

Like (0)

Report

Thanks all for your reply.

But If I use a different delimiter or use commaIo class my file is getting created in a different way,

So when I use this file for DMF import its throwing an error. If I use ',' delimiter file looks like this,

Thanks

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

CSV is a text format. Your images don't show CSV; they show how Microsoft Excel interprets your CSV texts.

If the default interpretation doesn't work for you (as in this case), use Data > From Text and select properties as needed.

Was this reply helpful? Yes No
Wekey 302 on at

Like (0)

Report

Hello Martin,

The problem is I am creating the csv file through code and using the file for DMF process in the code itself. I am trying something like this,

community.dynamics.com/.../msdyn365fo-execution-of-data-projects-through-x-code

Is there any suggestion for this?

Thanks

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Suggestion for what? You showed us a screenshot of an Excel spreadsheet, but now you seem to be saying that you problem isn't about Excel at all. The link is about importing data from code, so it sounds like you have some problem with it - but you didn't tell us what the problem is.

Also, what's the point of doing that? You're running X++ code to export data to a file, import this file again, get the original data and write it into a data entity. Why you don't you skip all the stuff about files and don't call the data entity directly?

Was this reply helpful? Yes No
Wekey 302 on at

Like (0)

Report

I am importing values from external sql DB. I am fetching records from external DB and creating a CSV file and creating a DMF project with that CSV this is what exactly I am trying.

Was this reply helpful? Yes No