[R] is it possible to use R to edit an EXCEL spreadsheet so I can create a searchable EXCEL database of R packages?

From: Bob Green <bgreen_at_dyson.brisnet.org.au>
Date: Tue 06 Dec 2005 - 10:58:24 EST

I have copied the R FAQ pertaining to available packages into an EXCEL file. They take the following form -

Regression modeling, testing, estimation, validation, graphics, prediction, and typesetting by storing enhanced model design attributes in the fit. Design is a etc.

Data sets and sample analyses from "Probability and Statistics for Engineering and the Sciences (5th ed)" by Jay L. Devore, 2000, Duxbury.

Presently the above format can be represented as:

package name
package description

I want to change the format so that file name and description are in adjacent columns and the space is removed

package name package description
package name package description

Is this possible in R so I can create a searchable EXCEL database of R packages. I imagine this would be easily carried out using PERL though was interested to know R's capacity to work on textual data?

Any assistance regarding this is appreciated,

Bob Green

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue Dec 06 14:46:46 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:41:29 EST