XLS in CSV with " and ;
You will find that Excel will put the quotation marks around a field of text
where it needs to, ie where the text contains a comma, and doesn't do so in
other cases, as it is not necessary. For eg if you opened the csv file in
Note pad you would see something like:
xx, yy yy, "xx,xx"
The first two strings do not need the quotation marks, but the third does as
it contains the delimiter used in the csv file, ie a comma.
--
Helena James
"Frank Matheis" wrote:
Hi there,
we have a XLS (Excel 2007) file and want to save it as *.csv in the format
like "datarecord";"datarecord2";"..... but Excel only uses ; and no " signs
between the data. Does anybody know how to get this solved?
Thank you in advance
Frank Matheis
|