[R] RE: (CSV files)
Peter Dalgaard BSA
p.dalgaard at biostat.ku.dk
Mon Dec 11 17:27:11 CET 2000
"Patrick Connolly" <P.Connolly at hortresearch.co.nz> writes:
> |> Danish settings will do that too as well as those of large parts of
> |> continental Europe. Hence the existence of read.csv2() and in 1.2 also
> |> read.delim2(). In fact some versions of Excel will write .csv in that
> |> format and then try to use the comma as separator when reading the
> |> file back in....
> |> (And SAS uses '.' and ',' when im/exporting CSV irrespective of
> |> locale, whereas SPSS uses ',' and ';' according to windows settings.
> |> So over here they can't read eachothers CSV files without substantial
> |> wand-waving. Sigh.)
> Perhaps I've missed something in the last 6 years or so, but I can't
> understand why anyone would bother with CSV files when what Excel
> calls a "Text (Tab delimited) *.txt" file seems to avoid any need for
> wand waving.
> Maybe I live in a sheltered environment.....
An English-language one for a start. Even TAB-separated files have the
decimal separator issue... Also, watch out with empty fields.
(And folklore has it that there are still emailers that do strange
things to TAB characters.)
O__ ---- Peter Dalgaard Blegdamsvej 3
c/ /'_ --- Dept. of Biostatistics 2200 Cph. N
(*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk) FAX: (+45) 35327907
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch
More information about the R-help