Sometimes even the easy stuff is difficult (for me)... I want to get input from different places to paste together an excel filename (so you know I'm using windows) that I can open with RODBC. I know about using double "\" since its an escape character, but I get either 2 or none, I can't get just one "\" where I need it. See example code below. I am using R 2.1.0, but plan to upgrade soon. Thanks in advance to anyone who can help. Roger rankPath <- "R:\New Ranks\SMC\SMC" rankDate <- "20050819" rankFile <- paste(rankPath,rankDate,".xls", sep="") rankFile [1] "R:New RanksSMCSMC20050819.xls" rankPath <- "R:\\New Ranks\\SMC\\SMC" rankDate <- "20050819" rankFile <- paste(rankPath,rankDate,".xls", sep="") rankFile [1] "R:\\New Ranks\\SMC\\SMC20050819.xls"
roger bos wrote:> Sometimes even the easy stuff is difficult (for me)... I want to get > input from different places to paste together an excel filename (so > you know I'm using windows) that I can open with RODBC. I know about > using double "\" since its an escape character, but I get either 2 or > none, I can't get just one "\" where I need it. See example code > below. I am using R 2.1.0, but plan to upgrade soon. Thanks in > advance to anyone who can help. > > Roger > > > rankPath <- "R:\New Ranks\SMC\SMC" > rankDate <- "20050819" > rankFile <- paste(rankPath,rankDate,".xls", sep="") > rankFile > [1] "R:New RanksSMCSMC20050819.xls" > > > rankPath <- "R:\\New Ranks\\SMC\\SMC" > rankDate <- "20050819" > rankFile <- paste(rankPath,rankDate,".xls", sep="") > rankFile > [1] "R:\\New Ranks\\SMC\\SMC20050819.xls"This is perfect, "\" is *printed* escaped, hence for file access you can perfectly use this character vector. Uwe Ligges> ______________________________________________ > R-help at 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
roger bos <roger.bos <at> gmail.com> writes:> Sometimes even the easy stuff is difficult (for me)... I want to get > input from different places to paste together an excel filename (soHave you considered a) the file.path() function, b) the fact that forward slashes also work on Windoze? Your first example, with an outer paste() for the suffix:> paste(file.path("R:", "New Ranks", "SMC", "SMC", "20050819"), ".xls", sep="")[1] "R:/New Ranks/SMC/SMC/20050819.xls">Hth, Dirk
> Sometimes even the easy stuff is difficult (for me)... I want to get > input from different places to paste together an excel filename (so > you know I'm using windows) that I can open with RODBC. I know aboutUsing file.path() might be an easier solution for this (and it will allow your code to work in a cross-platform manner)