Data Management Export Export CSV with Single Quote

(0) Share

Report

Posted on by Hossam Z. EL Hassan

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.

All responses (5)

Answers (3)

Sort by

Verified answer

Muhammad Ozair Naeem 272 on at

Like (0)

Report
Copy link

Link copied!

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.
Hossam Z. EL Hassan 28 on at

Like (0)

Report
Copy link

Link copied!

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?
Verified answer

Muhammad Ozair Naeem 272 on at

Like (0)

Report
Copy link

Link copied!

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

}

}
Verified answer

André Arnaud de Cal... 307,120 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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?
Hossam Z. EL Hassan 28 on at

Like (1)

Report
Copy link

Link copied!

Thanks everybody. I have tried to check the Text qualifier and the issue is resolved.