R help - May 2011 - Weird read.xls behavior

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]]

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 at 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.