12
Hi,
I have a problem when exporting data with CSV format if the data contains special characters which I believe is single quote in the description field. If I export the same data to excel I don't have the issue.
Is there a way to fix this problem.
Thanks everybody. I have tried to check the Text qualifier and the issue is resolved.
Hi Hossam,
Can you explain what exactly is your problem? You mentioned you have a problem but not what the problem is about. Can you provide an example?
If the removing the comma would not hurt the integrity of the data, you can have that done in the postLoad method of the entity by adding a virtual field. You can use regex to remove the comma there.
Sample of the postLoad Method.
[ExtensionOf(tableStr(SalesOrderHeaderV2Entity))]
final class Myclass_SalesOrderHeaderV2Entity_Extension
{
public void postLoad()
{
// Custom code
next postLoad();
// Custom code
}
}
Hi Muhamma,
I am exporting GL transactions. I tried to convert the Excel to CSV and it works well. The issue is only when I export directly to CSV.
What would be your recommendations?
Hi Hossam,
Could you elaborate more about the entity? Is it a custom entity? Or a screenshot?
I believe the issue is not with a quote but a comma. The CSV file actually separates the data with commas and an extra comma in your data is giving this issue. Have you tried converting your Excel exported data to a CSV file? Does that give an error too?
The comma can be removed before exporting as well in a method but that can destroy the integrity of the data. I'm not sure if escape characters can be of any help here.
#1
André Arnaud de Cal...
293,233
Super User 2025 Season 1
#2
Martin Dráb
231,923
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
