On Sat, Oct 23, 2010 at 9:20 AM, Dimitri Liakhovitski
<dimitri.liakhovit...@gmail.com> wrote:
> 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?
>I wonder if its just taking longer than you think. It does read the entire file into sqlite even if you only read a portion from sqlite to R so if the file is very long it will still take some time. Try creating a small file of a few hundred lines from your file and experiment on that until you get it working. -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.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.
