Hi,
I was wondering if it is possible to create a hyperlink in a csv file using
R code and some package. For example, in the following code:
links <- cbind(rep('Click for Google',3),"google search address
goes here")
## R Mailing list blocks if I put the actual web address here
write.table(links,'test.csv',
sep=',',row.names=F,col.names=F)
the web address should be linked to 'Click for Google'.
many thanks!
[[alternative HTML version deleted]]
Well you can write it there but it won't do anything until read into some software that can interpret it as a url. A csv file is just plain text. John Kane Kingston ON Canada> -----Original Message----- > From: bsmith030465 at gmail.com > Sent: Fri, 15 Mar 2013 07:53:02 -0400 > To: r-help at r-project.org > Subject: [R] Writing a hyperlink to a csv file > > Hi, > > I was wondering if it is possible to create a hyperlink in a csv file > using > R code and some package. For example, in the following code: > > links <- cbind(rep('Click for Google',3),"google search address goes > here") > ## R Mailing list blocks if I put the actual web address here > write.table(links,'test.csv', > sep=',',row.names=F,col.names=F) > > > the web address should be linked to 'Click for Google'. > > many thanks! > > [[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.____________________________________________________________ Send your photos by email in seconds... TRY FREE IM TOOLPACK at http://www.imtoolpack.com/default.aspx?rc=if3 Works in all emails, instant messengers, blogs, forums and social networks.
Le 15/03/13 12:53, Brian Smith a ?crit :> Hi, > > I was wondering if it is possible to create a hyperlink in a csv file using > R code and some package. For example, in the following code: > > links <- cbind(rep('Click for Google',3),"google search address goes here") > ## R Mailing list blocks if I put the actual web address here > write.table(links,'test.csv', > sep=',',row.names=F,col.names=F) > > > the web address should be linked to 'Click for Google'.The browseURL() function open your internet browser with the url indicated as parameter: browseURL("http://www.r-project.org") But I am not sure how you want call it. You should be more precise about the context you want to use it. For example: links <- data.frame(c(' for Google', ' for Bing'), c("http://www.google.com", "http://www.bing.com"), stringsAsFactors = FALSE) cat("Choose an option:\n", paste(1:2, links[,1],"\n")) f<-scan(nmax=1, quiet=TRUE) browseURL(links[f,2]) Sincerely Marc -- __________________________________________________________ Marc Girondot, Pr Laboratoire Ecologie, Syst?matique et Evolution Equipe de Conservation des Populations et des Communaut?s CNRS, AgroParisTech et Universit? Paris-Sud 11 , UMR 8079 B?timent 362 91405 Orsay Cedex, France Tel: 33 1 (0)1.69.15.72.30 Fax: 33 1 (0)1.69.15.73.53 e-mail: marc.girondot at u-psud.fr Web: http://www.ese.u-psud.fr/epc/conservation/Marc.html Skype: girondot