CSV Files

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Capn_Kidd
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

CSV Files

Post by Capn_Kidd » Thu Jan 31, 2008 11:20 am

I am trying to allow my users to save reports as CSV files. Unfortunately, these files are not being saved as I expected. I found out that numeric data is exported in fixed numeric format. When I modified the RSW.INI (I am using R&R Report Writer for SQL Version 9) and re-ran the reports, the resulting data was incorrect. Using the CSVKeepNumFormats=1 entry does keep my formatting but does not return the data as I expected. Here is a snippet of the problem I am having.__$42.99,89,$3,826,51.1%,$1,956,$981,42,,,47.2%,47.2%__The value $3,826 and $1,956 are read by Excel 2007 as two separate fields and not as one, since the values are not placed in quotes to signify them as one field. I would like the resulting file to look like this:__$42.99,89,"$3,826",51.1%,"$1,956",$981,42,,,47.2%,47.2%.__How do I get the report writer to place the currency fields in quotes? ____Thank you in advance for your assistance.

Post Reply