XLS in CSV with " and ;

  • Thread starter Thread starter Frank Matheis
  • Start date Start date
F

Frank Matheis

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
 
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.
 
Back
Top