Re: [R] reading csv files

2010-02-06 Thread analys...@hotmail.com
On Feb 5, 7:16 pm, Jim Lemon wrote: > On 02/06/2010 09:05 AM, analys...@hotmail.com wrote: > > > > > > > On Feb 5, 8:57 am, Barry Rowlingson > > wrote: > >> On Fri, Feb 5, 2010 at 10:23 AM, analys...@hotmail.com > > >>  wrote: > >>> the csv files are downloaded from a database and it looks like

Re: [R] reading csv files

2010-02-05 Thread Jim Lemon
On 02/06/2010 09:05 AM, analys...@hotmail.com wrote: On Feb 5, 8:57 am, Barry Rowlingson wrote: On Fri, Feb 5, 2010 at 10:23 AM, analys...@hotmail.com wrote: the csv files are downloaded from a database and it looks like some character fields contain the CR-LF sequence within them. This

Re: [R] reading csv files

2010-02-05 Thread analys...@hotmail.com
On Feb 5, 8:57 am, Barry Rowlingson wrote: > On Fri, Feb 5, 2010 at 10:23 AM, analys...@hotmail.com > > wrote: > > the csv files are downloaded from a database and it looks like some > > character fields contain the CR-LF sequence within them. > > > This causes R to see a new record/row and the

Re: [R] reading csv files

2010-02-05 Thread Jim Lemon
On 02/06/2010 12:57 AM, Barry Rowlingson wrote: On Fri, Feb 5, 2010 at 10:23 AM, analys...@hotmail.com wrote: the csv files are downloaded from a database and it looks like some character fields contain the CR-LF sequence within them. This causes R to see a new record/row and the number of ro

Re: [R] reading csv files

2010-02-05 Thread Barry Rowlingson
On Fri, Feb 5, 2010 at 10:23 AM, analys...@hotmail.com wrote: > the csv files are downloaded from a database and it looks like some > character fields contain the CR-LF sequence within them. > > This causes R to see a new record/row and the number of rows it sees > is different (usually higher) fr

[R] reading csv files

2010-02-05 Thread analys...@hotmail.com
the csv files are downloaded from a database and it looks like some character fields contain the CR-LF sequence within them. This causes R to see a new record/row and the number of rows it sees is different (usually higher) from the number of rows actually extracted. Any suggestions? Thanks. __

Re: [R] reading csv files - SYLK : file format not valid

2007-11-10 Thread Bob Green
Deng, Spot on. This was the problem - now the file opens perfectly. Thanks. Bob __ 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

Re: [R] reading csv files - SYLK : file format not valid

2007-11-10 Thread YH DENG
ject.org Subject: [R] reading csv files - SYLK : file format not valid I am wanting to read EXCEL files into R. In the past I have saved EXCEL files as csv files without difficulty. Recently, when I have saved the files in this format I am then unable to open them again in EXCEL or though windo

[R] reading csv files - SYLK : file format not valid

2007-11-10 Thread Bob Green
I am wanting to read EXCEL files into R. In the past I have saved EXCEL files as csv files without difficulty. Recently, when I have saved the files in this format I am then unable to open them again in EXCEL or though windows (XP). I receive a message stating - SYLK: file format not valid.