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.

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

Muhammad Ozair Naeem 272 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Hossam Z. EL Hassan 12 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Muhammad Ozair Naeem 272 on at

Like (0)

Report

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

}

}

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Hossam Z. EL Hassan 12 on at

Like (1)

Report

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

Was this reply helpful? Yes No