An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20100118/2c14fdf7/attachment.pl>
Exporting a data.frame to excel using sqlSave - adds a character ' to values
3 messages · Dieter Menne, Tal Galili
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.
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20100118/3054c96b/attachment.pl>