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

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
Check your csv file if the first field is "ID". If so then change it to something else or change it to "id". Deng -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Green Sent: Saturday, November 10, 2007 7:32 PM To: r-help@r-project.org Subject: [R] read