[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(\\..*$,

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 do it. On

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 fis...@plessthan.com wrote: R 3.0.2 OS X Colleagues I am writing

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

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 extracted

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 fis...@plessthan.com 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