What do you mean by Mixed? If a field has a comma, then it is supposed be to enclosed in quotes. You could preprocess the file looking for cases where there are more fields than there there are supposed to be, and if they are always in the same place, you could enclose them in quotes and then reprocess. You would really have to show what the file looks like for the different "mixed" cases to get a good answer to your question. And of course, R can do it, if we knew what it was we are supposed to do.
So at least provide commented, minimal, self-contained, reproducible code and data. On Fri, Mar 16, 2012 at 7:03 AM, Ashish Agarwal <ashish.agarw...@gmail.com> wrote: > I am having trouble reading this CSV file in R. There are six attributes > that I need to read - CVar1, CVar2, Location, Year, Nvar3, Nvar4. Can > somebody help in reading this file? > On line 10 it has city and state separated by comma. I had been a user of > SAS where I can use different format to read in for this line. Can I do > this in R too? > > ______________________________________________ > 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. > -- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. ______________________________________________ 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.
