Please help Export to CSV question 1

[mchsieh]

Hello friends,
I would like to export crystal report to csv.

Here is what I did:
1. Click export button.
2. choose "CSV FORMAT" AND "DISK FILE"
3. click "THE SAME NUMBER FORMATS AS IN REPORT" checkbox

However, I open the CSV file and find that "numberic type"
fields has double quotes. Anyone knows how to make them doesn't have double quotes.

Thank you,
mchsieh

 

[Timbe]

Dear Mchsieh:

Try the "character separated format", rather than comma separated. Leave a , as the separator, but then delete " from the the delimiter box.

--Timbe


*******************************************
Here is what I did:
1. Click export button.
2. choose "CSV FORMAT" AND "DISK FILE"
3. click "THE SAME NUMBER FORMATS AS IN REPORT" checkbox

However, I open the CSV file and find that "numberic type"
fields has double quotes. Anyone knows how to make them doesn't have double quotes.

Thank you,
mchsieh

 

[mchsieh]

Hi Timbe,
Thanks for your reply. If I try character separated values, I can get the no-double-quote numeric fields. However, I test 2 computer and just export to CSV format only. One can
get no-double-quote numeric fields, the other is not. I
tried many hours, but I can't figure out the reason. Any
further help would be greatly appreciated.

Do you think I could get no-double-quote numeric field
by "comma separated" value? If I know this, then I can
fix the other computer problem.

Thank you,
mchsieh