Export to CSV

[amartelr]

Good Day,

I'm trying to export a simple report to CSV enclosed each fields in double quotes like

Code: Select all

"{Data.Field}"

But the result of files generates 3 double quotes

Code: Select all

"""CONTENT"""

Thanks You

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue.
Please send us a sample report with test data for analysis.

Also, please clarify the product and version.

Thank you.

[amartelr]

Hello Lech, simply modify the first data column from your demo remports (SimpleTable) https://demo.stimulsoft.com/#Net/TableSimpleTable like this:

Code: Select all

"{Customers.CompanyName}"

And then save report to CSV you see this result, the first column has 3 double quotes instead of one

Code: Select all

"""Alfreds Futterkiste""",Obere Str. 57,030-0074321,Sales Representative
"""Ana Trujillo Emparedados y helados""",Avda. de la Constitución 2222,(5) 555-4729,Owner
"""Antonio Moreno Taquería""",Mataderos  2312,(5) 555-3932,Owner

Thank you

[HighAley]

Hello,

The double quotes are added automatically if it's necessary.
When you add the double quotes they are interpreted and text and they are doubled.
In additional, the double quotes are added to the whole text.

Thank you.

[amartelr]

Hello,

So if I want all the fields to be in double quotes. How should i do. If you see the previous example, don't have double quotes, even being fields of type string.

Thank you

[HighAley]

Hello,

At this moment our tool adds double quotes if it's necessary.
If you need to get the double quotes in all fields, please, send us a feature request.

Thank you.