[R] paste0 in file path

[Uwe Ligges]

On 31.08.2016 17:50, Leslie Rutkowski wrote:
> Hi,
>
> I'm trying to reshape and output 8 simple tables into excel files. This is
> the code I'm using
>
>   for (i in 1:8) {
>   count <- table(mydata$ctry, mydata[,paste0("q0",i,"r")])
>   dat <- as.data.frame(q01count)
>
>   wide <- reshape(dat,
>                   timevar="Var2",
>                   idvar="Var1",
>                   direction="wide")
>    write.xlsx(wide, file=paste0(i, 'C:/temp/q0',i,'r.xlsx'))

                                   ^^
remove the i?

Best,
Uwe Ligges


>   }
>
> All goes well until the write.xlsx, which produces the error
>
> Error in .jnew("java/io/FileOutputStream", jFile) :
>   java.io.FileNotFoundException: 1C:\temp\q01r.xlsx (The filename,
> directory name, or volume label syntax is incorrect)
>
> Among other things, I'm puzzled about why a "1" is getting tacked on to the
> file path.
>
> Any hints?
>
> Thanks,
> Leslie
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
>