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]] > > ______________________________________________ > [email protected] 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. ______________________________________________ [email protected] 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.
