If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
XLS in CSV with " and ;
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|