Elvis, first, keep things on the list - so others can learn and comment. Second, as Sarah already commented: We do not like to open unsolicited binary attachments on the list. Sarah gives a good hint how to post data to the list.
What I would do so far is use the matching columns to get the names you need from BTemperature: temp_inv <- read.table("Temperature Inventory", … ) (here I would change the .xlsx to a .csv and use read.csv instead of read.table) btemp <- read.table(“BTemperature_Stations.txt”, … ) (again think about converting via Excel to .csv - it makes things far more easy) Check ?read.table for options - you gonna need them. Then match mynames <- btemp[(temp_inv[,3] %in% btemp[, 3]), 2] Now you have the names of the stations and if your .txt files are named by the stations you can do something like: for (name in mynames) { tmp.table <- read.table(paste(“path/to/your/Homog_daily_min_temp/“, name, “.txt”, sep = “”), … ) …. do things with the data } Best Simon On 08 Nov 2013, at 19:26, Zilefac Elvis <zilefacel...@yahoo.com> wrote: > Hi Simon, > Attached are my data files. > Btemperature_Stations is my main file. > Temperature inventory is my 'wanted' file and is a subset of > Btemperature_Stations. > Using column 3 in both files, select the files in Temperature inventory from > Btemperature_Stations. > The .zip file contains the .txt files which you will extract to a folder and > do the selection in R. > > Thanks, > Atem. > > > > > > On Friday, November 8, 2013 11:54 AM, Simon Zehnder <szehn...@uni-bonn.de> > wrote: > If you want to type in the names by hand, you can simply use read.table to > load them into R … I still don’t get the aim of your text file handling > > > On 08 Nov 2013, at 18:51, Zilefac Elvis <zilefacel...@yahoo.com> wrote: > > > All files are text files. They are found in a folder on my computer. > > Assume that I know the names of some of the files I want to select from the > > 300 txt files. > > How can I do this in R. > > Atem. > > > > > > On Friday, November 8, 2013 11:44 AM, Simon Zehnder <szehn...@uni-bonn.de> > > wrote: > > I do not understand the question. If you already know the names what is the > > problem to select the files by names? > > > > If you have the names but not inside of R you have to find a name pattern > > to avoid typing them in. Is there a pattern, e.g. da.txt, db.txt, dc.txt? > > > > > > On 08 Nov 2013, at 18:33, Zilefac Elvis <zilefacel...@yahoo.com> wrote: > > > > > Hi, > > > I have 300 .txt files in a directory. Out of this 300, I need just 100 of > > > the files. > > > I have the names of the 100 .txt files which are also found in the 300 > > > .txt files. > > > How can I extract only the 100 .txt files from the 300 ,txt files? > > > > > > e.g given d1.txt, ds.txt, dx.txt, df.txt...d300.txt, how can I select > > > only d1.txt and df.txt? Remember, I have 300 of such and want to extract > > > 100 of them with names known. > > > > > > Thanks for your great help. > > > Atem. > > > > > [[alternative HTML version deleted]] > > > > > > ______________________________________________ > > > R-help@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. > > > > > > > > > <BTemperature_Stations.txt><Tempearture > inventory.xlsx><Homog_daily_min_temp.zip> ______________________________________________ R-help@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.