[R] Substituting in a variable file name in a Windows system command
Duncan Murdoch
murdoch at stats.uwo.ca
Fri Feb 27 00:34:46 CET 2009
Elaine Jones wrote:
> I am running R version 2.8.1 on Windows XP OS.
>
> I generate and write a .csv file from my R script. Then the following
> command works to upload it to a remote server using a windows batch file
> that carries out the ftp (among other things).
>
> > system("C:/upload_data/uploadq8.bat
> C:/upload_data/out_2009-02-26.csv", wait=FALSE)
>
> I want to set this up to run daily and create a unique filename each day it
> runs. I write the .csv file with a unique filename by
>
> > fname <- paste("out_",Sys.Date(),".csv",sep="")
>
> > write.table(config_all5,file=fname,row.names=FALSE,
> quote=FALSE,sep=",");
>
> I can build the string (including quotes) that is the first argument in
> the system command:
>
Don't include the quotes.
> > com <- paste('"C:/upload_data/uploadq8table.bat
> C:/upload_data/',fname,'"', sep="")
>
Should be
com <- paste('C:/upload_data/uploadq8table.bat
C:/upload_data/',fname, sep="")
Duncan Murdoch
> > com
> [1] "\"C:/upload_data/uploadq8table.bat
> C:/upload_data/out_2009-02-26.csv\"",
>
> But when I substitute it into the system command I get an error:
> > system(com, wait=FALSE)
> Warning in system(com, wait = FALSE) :
> "C:/upload_data/uploadq8table.bat C:/upload_data/out_2009-02-26.csv"
> not found
> >
>
> Any suggestions for how to resolve are appreciated!
>
> **************** Elaine McGovern Jones ************************
>
> ISC Tape and DASD Storage Products
> Characterization and Failure Analysis Engineering
> Phone: 408 284 4853 Internal: 3-4853
> jones2 at us.ibm.com
>
>
>
>
> [[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.
>
More information about the R-help
mailing list