.csv with double quotes

S

SWMagic

Worker in office has been "saving as" a csv file for well over a year.
Suddenly when I save it now it creates a csv file that does NOT hav
the quotes around each field as it had before. Not much information o
Google about this.

Even tried saving with CSV for Windows and CSV for Dos and both wit
and without the Worksheet.

Confused.

Thanks,
Pau
 
E

Earl Kiosterud

SW,

If there are fields with quotes in them, then quotes should be put around
the field (and the quotes in the data should be doubled up). And if there
are commas, quotes should be around the field also. If it isn't doing that
in those conditions, check your Windows Regional Settings. Make sure the
list separator is set to comma. For more information, look at "Excel and
Text files" at www.smokeylake.com/excel.
 
S

SWMagic

Thanks for your quick response Earl.

I reviewed your link. I'm know I don't want 2 quotes around text
fields which are already quoted.

The Regional settings are set to comma as you recommended but that
doesn't change the file save as. Good point though as the user is
saving on another machine, not the one used for the year...(is this a
hint?)

When I open the csv file in Excel it looks just great...even no quotes
around strings. When I save as csv file and look at it in Notepad,
some fields have quotes around them, some don't...almost as though
Excel knew and preserved the quotes from the original file. BTW each
field has a general description.

So how do I save this so that I get quotes around each field...without
double quotes appearing?

Paul
 
D

Dodo

So how do I save this so that I get quotes around each field...without
double quotes appearing?
Click to expand...

If I remember correctly (I used to do this regularly years ago but not
recently) Excel cannot produce a proper CSV file. That is why I always
saved it as dBase III and converted it in a different program to CSV. That
result was always perfect.
What was that prog? CrystalReports?
 
E

Earl Kiosterud

SW,

This still isn't clear to me. Can you give some examples of what's in
cells, and what was saved (as seen in Notepad)?
 
Top