Thanks Dieter, Reading it back is fine, but still - I wish I could control this behavior.
Tal ----------------Contact Details:------------------------------------------------------- Contact me: tal.gal...@gmail.com | 972-52-7275845 Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) | www.r-statistics.com/ (English) ---------------------------------------------------------------------------------------------- On Mon, Jan 18, 2010 at 3:49 PM, Dieter Menne <dieter.me...@menne-biomed.de>wrote: > > > > Tal Galili wrote: > > > > I am using RODB to export multiple data.frames into one excel file with > > multiple sheets. > > One thing I can't seem to unserdatand is way the command adds the > > character: > > ' > > To the beginning of each of my (non numeric) values. > > > > This might be a problem of you running in Hebrew locale; on my machine > (German) this does not occur. However, I can manually add a ' in front both > of numbers and texts to denote the column as a string; the ' only shows up > in the edit field on the top row, not in the data, indicating that this is > a > "forced string" value. > > Try to read back you data. I believe your strings will be ok. > > Dieter > > > -- > View this message in context: > http://n4.nabble.com/Exporting-a-data-frame-to-excel-using-sqlSave-adds-a-character-to-values-tp1016523p1016632.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
