1,189
Hi All,
when we try to open the csv file with note pad after it was exported from AX through the closedXML library, the file opens in different format with different characters inside as per below pic , so we have to manually save the file as csv comma delimted then it open with correct format, how can we solve this issue that after the export it opens in right format ?
Thank you,
Sorry, actually you need to use TextIO instead of CommaIO if you don't want to have the quotation marks. In normal CSV string values are surrounded by quotation marks, to avoid issues where the string field contains the delimiter character (such as comma).
Are you sure it's not ok to have the quotation marks there? I would assume that the application who reads this file knows how to handle it.
Instead of removing, I would focus on not writing the quotation marks in the file in the first place.
How to do that in your case depends quite a lot on your implementation. Perhaps you can share your code, then we can suggest how to change it?
Hi Martin,
i have a question please :
we are trying to generate a csv file when the WF is completed. the file is generated successfully but when we try to open it with note pad the value appear with "" is there any way to remove the "" .
Thank you
This is not a CSV file. It's an Excel file, which isn't a huge surprise, since you used a library for working with Excel files.
So either your fine with getting an Excel file, or you'll have to change your implementation.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (