Kenneth, Thanks for the reply. I checked the original data. There is no space. I even manually added a space to one value. After reading in with read.xls, the value has two spaces. The reason I don't like it is I am going to do some comparison with another dataset, which is supposed to be the same as this one. Now I am getting a bunch of false negatives.
Jun On Mon, May 9, 2011 at 11:01 PM, Kenneth Roy Cabrera Torres < krcab...@une.net.co> wrote: > Maybe in the original there are some "ghost" spaces after ng/ml, > verify them. > > Any way you can erase the first and the last white spaces with gsub > function. > > HTH > > Kenneth > El lun, 09-05-2011 a las 22:44 -0500, Jun Shen escribió: > > Dear list, > > > > I used read.xls to read in an excel file, which has both character and > > numeric columns. Everything seems fine except in the last column, I have > > this character value "ng/ml". When reading in, read.xls seems to add a > space > > at the end of it, became "ng/ml ". How can I prevent read.xls doing so? > > Thanks. > > > > >read.xls(data, header=T, as.is=T) > > > > Jun > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > 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. > > > [[alternative HTML version deleted]]
______________________________________________ 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.
