Page 1 of 1

Export to CSV

Posted: Mon Sep 14, 2020 9:08 am
by 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

Re: Export to CSV

Posted: Tue Sep 15, 2020 6:48 am
by 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.

Re: Export to CSV

Posted: Tue Sep 15, 2020 7:17 am
by 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

Re: Export to CSV

Posted: Tue Sep 15, 2020 9:38 am
by 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.

Re: Export to CSV

Posted: Wed Sep 16, 2020 7:19 am
by 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

Re: Export to CSV

Posted: Mon Sep 21, 2020 10:34 am
by 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.