thr3ads.net - R help - [R] How to open a file with a name changed? [May 2012]

If this information is useful, please help other people find it:
Share via:

Minerva Mora

2012-May-24 23:45 UTC

[R] How to open a file with a name changed?

Hi, I apologize for my english.

I?m trying to read a file, but the name of this file changes every day, for
example: today is May 24, 2012

bonos<- read.table("C:/Bonos/*20120524*.csv", header=TRUE,
sep="\t")

So, tomorrow I want to read the file again, but i don?t want to put the date
by myself, i want this automatically. I know that if a put day() this
instruccion gives me the date.

My problem is, I don?t know how to concatenate these:
-"C:/Bonos/
-the date
-.csv"
 
I tried this:
bonos<- read.table(cat(cit,dia,extension), header=TRUE, sep="\t")
where
--cit is *"\"C:/Bonos/"*
--dia is *dia<-format(today, "%Y%m%d")*
--extension is *extension<-".csv\""*

but i have this problem:
"C:/Bonos/ 20120524 .csv"*Error in read.table(cat(cit, dia,
extension),
header = TRUE, sep = "\t") : * * 'file' must be a character
string or
connection*

What can i do?

Thanks!

--
View this message in context:
http://r.789695.n4.nabble.com/How-to-open-a-file-with-a-name-changed-tp4631261.html
Sent from the R help mailing list archive at Nabble.com.

Rolf Turner

2012-May-25 00:38 UTC

head link

[R] How to open a file with a name changed?

?paste

On 25/05/12 11:45, Minerva Mora wrote:> Hi, I apologize for my english.
>
> I?m trying to read a file, but the name of this file changes every day, for
> example: today is May 24, 2012
>
> bonos<- read.table("C:/Bonos/*20120524*.csv", header=TRUE,
sep="\t")
>
> So, tomorrow I want to read the file again, but i don?t want to put the
date
> by myself, i want this automatically. I know that if a put day() this
> instruccion gives me the date.
>
> My problem is, I don?t know how to concatenate these:
> -"C:/Bonos/
> -the date
> -.csv"
>
> I tried this:
> bonos<- read.table(cat(cit,dia,extension), header=TRUE,
sep="\t")
> where
> --cit is *"\"C:/Bonos/"*
> --dia is *dia<-format(today, "%Y%m%d")*
> --extension is *extension<-".csv\""*
>
> but i have this problem:
> "C:/Bonos/ 20120524 .csv"*Error in read.table(cat(cit, dia,
extension),
> header = TRUE, sep = "\t") : * * 'file' must be a
character string or
> connection*
>
> What can i do?
>
> Thanks!
>
> --
> View this message in context:
http://r.789695.n4.nabble.com/How-to-open-a-file-with-a-name-changed-tp4631261.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.

Steve Taylor

2012-May-25 00:43 UTC

head link

[R] How to open a file with a name changed?

You probably want to use paste or paste0 instead of cat.
paste0(cit,dia,extension)

Also, this might work: 
tail(dir("C:/Bonos/",patt="csv$"),1)


-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org]
On Behalf Of Minerva Mora
Sent: Friday, 25 May 2012 11:45a
To: r-help at r-project.org
Subject: [R] How to open a file with a name changed?

Hi, I apologize for my english.

I?m trying to read a file, but the name of this file changes every day, for
example: today is May 24, 2012

bonos<- read.table("C:/Bonos/*20120524*.csv", header=TRUE,
sep="\t")

So, tomorrow I want to read the file again, but i don?t want to put the date
by myself, i want this automatically. I know that if a put day() this
instruccion gives me the date.

My problem is, I don?t know how to concatenate these:
-"C:/Bonos/
-the date
-.csv"
 
I tried this:
bonos<- read.table(cat(cit,dia,extension), header=TRUE, sep="\t")
where
--cit is *"\"C:/Bonos/"*
--dia is *dia<-format(today, "%Y%m%d")*
--extension is *extension<-".csv\""*

but i have this problem:
"C:/Bonos/ 20120524 .csv"*Error in read.table(cat(cit, dia,
extension),
header = TRUE, sep = "\t") : * * 'file' must be a character
string or
connection*

What can i do?

Thanks!

--
View this message in context:
http://r.789695.n4.nabble.com/How-to-open-a-file-with-a-name-changed-tp4631261.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
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.

David Winsemius

2012-May-25 01:34 UTC

head link

[R] How to open a file with a name changed?

On May 24, 2012, at 7:45 PM, Minerva Mora wrote:
> Hi, I apologize for my english.
>
> I?m trying to read a file, but the name of this file changes every  
> day, for
> example: today is May 24, 2012
>
> bonos<- read.table(*20120524*.csv", header=TRUE,
sep="\t")
>
yr = "2012"
mo = "01
dt = "25"
filnam =paste("C:/Bonos/" , yr, mo, dt,sep="")

bonos <- read.table(filnam, header=TRUE, sep="\t")

> So, tomorrow I want to read the file again, but i don?t want to put  
> the date
> by myself, i want this automatically. I know that if a put day() this
> instruccion gives me the date.
>
> My problem is, I don?t know how to concatenate these:
> -"C:/Bonos/
> -the date
> -.csv"
>
> I tried this:
> bonos<- read.table(cat(cit,dia,extension), header=TRUE,
sep="\t")
> where
> --cit is *"\"C:/Bonos/"*
> --dia is *dia<-format(today, "%Y%m%d")*
> --extension is *extension<-".csv\""*
>
> but i have this problem:
> "C:/Bonos/ 20120524 .csv"*Error in read.table(cat(cit, dia,  
> extension),
> header = TRUE, sep = "\t") : * * 'file' must be a
character string or
> connection*
>
> What can i do?
>
> Thanks!
>
> --
> View this message in context:
http://r.789695.n4.nabble.com/How-to-open-a-file-with-a-name-changed-tp4631261.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
David Winsemius, MD
West Hartford, CT

David Winsemius

2012-May-25 01:49 UTC

head link

[R] How to open a file with a name changed?

On May 24, 2012, at 7:45 PM, Minerva Mora wrote:
> Hi, I apologize for my english.
>
> I?m trying to read a file, but the name of this file changes every  
> day, for
> example: today is May 24, 2012
>
> bonos<- read.table("C:/Bonos/*20120524*.csv", header=TRUE,
sep="\t")
>
> So, tomorrow I want to read the file again, but i don?t want to put  
> the date
> by myself, i want this automatically. I know that if a put day() this
> instruccion gives me the date.
>
> My problem is, I don?t know how to concatenate these:
> -"C:/Bonos/
> -the date
> -.csv"
>
or even :

paste( gsub("-", "", Sys.Date() ) )
[1] "20120524"

filname <- paste("C:/Bonos/", gsub("-", "",
Sys.date() ) , sep="")

-- 
David.

> I tried this:
> bonos<- read.table(cat(cit,dia,extension), header=TRUE,
sep="\t")
> where
> --cit is *"\"C:/Bonos/"*
> --dia is *dia<-format(today, "%Y%m%d")*
> --extension is *extension<-".csv\""*
>
> but i have this problem:
> "C:/Bonos/ 20120524 .csv"*Error in read.table(cat(cit, dia,  
> extension),
> header = TRUE, sep = "\t") : * * 'file' must be a
character string or
> connection*
>
> What can i do?
>
> Thanks!
>
> --
> View this message in context:
http://r.789695.n4.nabble.com/How-to-open-a-file-with-a-name-changed-tp4631261.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
David Winsemius, MD
West Hartford, CT

peter dalgaard

2012-May-25 06:45 UTC

head link

[R] How to open a file with a name changed?

On May 25, 2012, at 02:38 , Rolf Turner wrote:
> ?paste
or ?sprintf, which might lead to more readable code. Also
> format(today, "C:/Bonos/%Y%m%d.csv")[1] "C:/Bonos/20120525.csv"


> On 25/05/12 11:45, Minerva Mora wrote:
>> Hi, I apologize for my english.
>> 
>> I?m trying to read a file, but the name of this file changes every day,
for
>> example: today is May 24, 2012
>> 
>> bonos<- read.table("C:/Bonos/*20120524*.csv", header=TRUE,
sep="\t")
>> 
>> So, tomorrow I want to read the file again, but i don?t want to put the
date
>> by myself, i want this automatically. I know that if a put day() this
>> instruccion gives me the date.....

-- 
Peter Dalgaard, Professor,
Center for Statistics, Copenhagen Business School
Solbjerg Plads 3, 2000 Frederiksberg, Denmark
Phone: (+45)38153501
Email: pd.mes at cbs.dk  Priv: PDalgd at gmail.com

Minerva Mora

2012-May-30 15:34 UTC

head link

[R] How to open a file with a name changed?

Hi!!
Thanks everybody... 
It works with *filname <- paste("C:/Bonos/", gsub("-",
"", Sys.date() ) ,
sep="")*



--
View this message in context:
http://r.789695.n4.nabble.com/How-to-open-a-file-with-a-name-changed-tp4631261p4631840.html
Sent from the R help mailing list archive at Nabble.com.

Seemingly Similar Threads

Search for more possibly parallel threads

R help - May 2012 - How to open a file with a name changed?

[R] How to open a file with a name changed?

[R] How to open a file with a name changed?

[R] How to open a file with a name changed?

[R] How to open a file with a name changed?

[R] How to open a file with a name changed?

[R] How to open a file with a name changed?

[R] How to open a file with a name changed?

Seemingly Similar Threads