Re: [R] Regular expressions on filenames

2014-01-15 Thread Wojtek Poppe
Try sub("\\.[^.]+$", "", basename(FILELIST)) Thanks, Wojtek On Wed, Jan 15, 2014 at 4:37 PM, Fisher Dennis wrote: > R 3.0.2 > OS X > > Colleagues > > I am writing code to read a large number of files in a particular folder. > In some situations, there may be two versions of the file with di

Re: [R] Regular expressions on filenames

2014-01-15 Thread David Winsemius
On Jan 15, 2014, at 4:37 PM, Fisher Dennis wrote: > R 3.0.2 > OS X > > Colleagues > > I am writing code to read a large number of files in a particular folder. In > some situations, there may be two versions of the file with different > extensions, e.g.: > FILE.csv > FILE.xls > I

Re: [R] Regular expressions on filenames

2014-01-15 Thread Jeff Newmiller
You want to match a period and anything that follows to the end of the string, as long as what follows has no period in it. "\\.[^.]*$" --- Jeff NewmillerThe . . Go Live... DCN:

Re: [R] Regular expressions on filenames

2014-01-15 Thread arun
Hi, Try:  FILELIST <- list.files() FILELIST #[1] "FILE.csv" "FILE.XXX.csv" "FILE.YYY.xls"   sub("(.*)\\..*$", "\\1", basename(FILELIST)) #[1] "FILE" "FILE.XXX" "FILE.YYY" A.K. On Wednesday, January 15, 2014 7:35 PM, Fisher Dennis wrote: R 3.0.2 OS X Colleagues I am writing code to

Re: [R] Regular expressions on filenames

2014-01-15 Thread jim holtman
try this: > x <- c( "FILE.XXX.csv" + , "FILE.YYY.xls") > sub("\\.[^.]*$", "", x) [1] "FILE.XXX" "FILE.YYY" > the '[^.]*' says to match anything BUT a period. Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to

[R] Regular expressions on filenames

2014-01-15 Thread Fisher Dennis
R 3.0.2 OS X Colleagues I am writing code to read a large number of files in a particular folder. In some situations, there may be two versions of the file with different extensions, e.g.: FILE.csv FILE.xls I extracted the portion before the extension with: sub("\\..*$"