XLS in CSV with " and ;

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
 
H

Helena James

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top