Thank you Jim for your reply. I could figure out that readLines works fine until 35,841,335 lines (records).
When the next line is read to be read, a window with "R for Windows GUI front-end has stopped working" message comes, with an option to close program or checking online for a solution. The tab-separated .txt file I am working on has 9 columns and about 3.25 billion rows. I suspect that the 35,841,336th line is becoming so very big that RAM out runs its capacity. Perhaps all tabs that are expected after each values are missing, making the line so very big, I am not sure. Is there any way to skip this line with readLines or any other function? I am only hoping that the data after this bad line is good and I can read them if I can skip the bad one. Thank you. HC -- View this message in context: http://r.789695.n4.nabble.com/sqldf-for-Very-Large-Tab-Delimited-Files-tp4350555p4357730.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.
