Export csv
Don Bush
don at caffco.com
Fri Aug 19 06:31:05 PDT 2005
we had the same problem. it looks like excel is looking for the " to
decide if the comma is a delimiter or not.
We just changed our export to tab delimited instead CSV.
Don Bush
CCC Associates Inc.
At 10:20 PM 8/18/2005, GCC wrote:
>Created an export to a csv file as I have done many times.
>
>The export is a list of stores with the first column being the store number.
>Each record consist of 45 fields which are being outputted.
>
>Everything worked fine except when I checked the file in Excel, I found the
>store 40's data was on the same line as store 39 but started at the column for
>field 35.
>
>Every other line was correct.
>
>I tested the output by just selecting store 39. The data was correct.
>
>I tested the output just for store 40, and it was correct.
>
>Testing both, again everything on one line.
>
>The one think I found in checking field 35 for store 39, was a dimension field
>having 8'X72".
>
>When I changed this to 8'X6' everything worked correctly.
>
>Column 35, when 8'X72" looked like this 8"X72","","" and then the second field
>for store 40 and the next 10 fields of data from store 40.
>
>Can anyone tell me why the 72"(inch) caused this problem? How would one avoid
>the problem if the " was a necessary part of the text field?
>
>Richard Kreiss
>GCC Consulting
>
>
>
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list