report builder (OpenInsight 32-Bit)
At 02 MAR 2006 10:57:35PM Jim Vaughan wrote:
Is it possible to get rid of the quotes that surround all the fields when you create a csv file via report builder?
At 03 MAR 2006 08:27AM Bill Reynaldos wrote:
That probably belongs in the Suggestions section of the Bug Tracker.
At 03 MAR 2006 11:50AM Jim Vaughan wrote:
So does that mean, no; I can not remove the quotes?
At 03 MAR 2006 12:58PM Bob Orsini wrote:
Jim, the csv file was intended to load a report into excel. The quotes were inserted so the data would not be corrupted by having quotes imbedded in money amounts or names. There currently is not an option to create the file without quotes unless you use the text output whcih reates a file that is space delimitted between columns.
At 03 MAR 2006 03:43PM Jim Vaughan wrote:
Hmm, the problem with that is if you open the csv file in Access then the quotes get left in the data (not very helpful). Maybe I need to do this via xml.
Any idea what causes the other problem (the missing code).
At 03 MAR 2006 04:45PM Jim Vaughan wrote:
FYI in case anyone else hits this:
(1) Export the data using the reporter in csv format, assume the file name is report.csv
(2) Once the file has been created rename the file to report.txt
(3) Open report.txt in Access, which will then walk you through importing the data using a wizard.
(4) At the first prompt, choose delimited (the default) and click the Next button.
(5) Set the delimiter to comma (the default), check the box for first row contains field names, and set the text qualifier to be a double quote (") via the dropdown.
(6) Click the Finish button
At 05 MAR 2006 12:59PM dsig _at_ sigafoos.org wrote:
But isn't the 'standard' in the industry to only DQuote fields that are text? If you do a csv export from excel wont it leave the 'numeric' fields alone? I thought it did
At 05 MAR 2006 02:07PM Gerald Lovel wrote:
"But isn't the 'standard' in the industry to only DQuote fields that are text?"
I have seen it both ways. Basic+ is untyped, so all fields are text and require quotes by your statement. But I have also seen where fields receive quotes only when the content includes a comma, text or not.
At 06 MAR 2006 12:46PM Jim Vaughan wrote:
Well it looks like my work around was not good enough for my customer. I will write a small c utility that I can have her run after creating the report that strips out quotes. Hopefully that will do the trick.
At 07 MAR 2006 10:35AM dsig _at_ sigafoos.org wrote:
in fact if you look at crystal reports, excel heck even OO you will see that they export CSV as Dquote around text only.
And yes .. OI is string based but it does not mean that the program that is building the CSV (starting with the report builder) is incapable of knowing FROM THE DICT if it is text or numeric.