Re: [R] Using sqldf() to read in .fwf files

2014-09-15 Thread Gabor Grothendieck
On Mon, Sep 15, 2014 at 3:23 PM, Doran, Harold wrote: > Thank you, Gabor. This has seemingly resolved the issue. Perhaps a quick > follow up. Suppose I know that the 1st variable I am reading in is to be > numeric and the second is character. Can that be specified in the substr() > argument? >

Re: [R] Using sqldf() to read in .fwf files

2014-09-15 Thread Doran, Harold
from fixed") -Original Message- From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com] Sent: Monday, September 15, 2014 12:42 PM To: Doran, Harold Cc: r-help@r-project.org Subject: Re: [R] Using sqldf() to read in .fwf files On Mon, Sep 15, 2014 at 12:09 PM, Doran, Harold wro

Re: [R] Using sqldf() to read in .fwf files

2014-09-15 Thread Gabor Grothendieck
On Mon, Sep 15, 2014 at 12:09 PM, Doran, Harold wrote: > I am learning to use sqldf() to read in very large fixed width files that > otherwise do not work efficiently with read.fwf. I found the following > example online and have worked with this in various ways to read in the data > > cat("1 8.

[R] Using sqldf() to read in .fwf files

2014-09-15 Thread Doran, Harold
I am learning to use sqldf() to read in very large fixed width files that otherwise do not work efficiently with read.fwf. I found the following example online and have worked with this in various ways to read in the data cat("1 8.3 210.3 319.0 416.0 515.6 719.8 ", file = "fixed") fixed <- file