An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20131216/862794fd/attachment.pl>
read ".slk" file
5 messages · PIKAL Petr, Jeff Newmiller, David Winsemius +1 more
1 day later
Hi Extension does not specify file format. You can rename any file with any extension without changing its nature. However slk stays for symbolic link and therefore it just brings actual file to Excel. Maybe you could start to play with http://stat.ethz.ch/R-manual/R-devel/library/base/html/files.html Regards Petr
-----Original Message----- From: r-help-bounces at r-project.org [mailto:r-help-bounces at r- project.org] On Behalf Of Santosh Sent: Tuesday, December 17, 2013 12:11 AM To: r-help Subject: [R] read ".slk" file Dear Rxperts.. I recently received a data file with the extension ".slk". If I save the file as MS Excel file, I am able to read in R without issues. Is it possible to read this ".slk" file without converting into another R- readable data format? Regards, Santosh [[alternative HTML version deleted]]
______________________________________________ R-help at 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.
I suspect this could be SYLK format, a very old spreadsheet exchange format. The only hit that I get from RSiteSearch("sylk") is read.gnumeric.sheet, which depends on an external program "ssconvert" to extract CSV. In the plus department, it is a text-based format that has been implemented numerous times so you could roll your own reader based on open source code. In the minus department, there is no published specification, so if your files have quirks then you will have to work around them one by one, and it really is like Latin... a dead language.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
PIKAL Petr <petr.pikal at precheza.cz> wrote:
Hi Extension does not specify file format. You can rename any file with any extension without changing its nature. However slk stays for symbolic link and therefore it just brings actual file to Excel. Maybe you could start to play with http://stat.ethz.ch/R-manual/R-devel/library/base/html/files.html Regards Petr
-----Original Message----- From: r-help-bounces at r-project.org [mailto:r-help-bounces at r- project.org] On Behalf Of Santosh Sent: Tuesday, December 17, 2013 12:11 AM To: r-help Subject: [R] read ".slk" file Dear Rxperts.. I recently received a data file with the extension ".slk". If I save the file as MS Excel file, I am able to read in R without issues. Is it possible to read this ".slk" file without converting into another
R-
readable data format? Regards, Santosh [[alternative HTML version deleted]]
______________________________________________ R-help at 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.
______________________________________________ R-help at 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.
On Dec 16, 2013, at 3:10 PM, Santosh wrote:
Dear Rxperts.. I recently received a data file with the extension ".slk". If I save the file as MS Excel file, I am able to read in R without issues. Is it possible to read this ".slk" file without converting into another R-readable data format?
Reading this I wondered if you could use sep=";" with read.* functions. http://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29 That is NOT going to give you a neat dataframe, but you didn't make your goals very clear so it seems possible that you might get what you needed from some selected input lines.
David Winsemius Alameda, CA, USA
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20131219/213109ee/attachment.pl>