This is very helpful, Gabor.
I've run the code to figure out the end of the line and here is what I
am seeing at the end of each line: \r\n
So, I specified like this:
mydata<-read.csv.sql("myfile.txt", sep="|", eol="\r\n", sql = "select
* from file limit 200, 100")
However, again it's hanging again. Another typo?
On Sat, Oct 23, 2010 at 8:22 AM, Gabor Grothendieck
<ggrothendi...@gmail.com> wrote:
> On Sat, Oct 23, 2010 at 7:44 AM, Dimitri Liakhovitski
> <dimitri.liakhovit...@gmail.com> wrote:
>> Gabor,
>> maybe some of my code is wrong (I don't know sql at all). I tried the
>> following with just a few lines as a test:
>> library(sqldf)
>> mydata<-read.csv.sql("myfile.txt",sep="|", sql = "select * from file 200,
>> 100")
>
> "limit" was missing in my post. It should be:
>
> mydata<-read.csv.sql("myfile.txt",sep="|", sql = "select * from
> file limit 200, 100")
>
> Usually hangs mean that eol is wrong. Also try not specifying eol as
> well as eol = "\n", eol = "\r" and eol = "\r\n" and see if any of
> those work (after correcting the missing "limit").
>
> You can also verify what the end of line characters are directly by
> reading in sufficient characters in binary so that at least one line
> is read in. If the first line has fewer than 1000 characters then, in
> R:
>
> L <- readBin("myfile.csv", "raw", 1000)
> rawToChar(L)
>
> --
> Statistics & Software Consulting
> GKX Group, GKX Associates Inc.
> tel: 1-877-GKX-GROUP
> email: ggrothendieck at gmail.com
>
--
Dimitri Liakhovitski
Ninah Consulting
www.ninah.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.
