View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon[_21_] Jon[_21_] is offline
external usenet poster
 
Posts: 37
Default removing the file extension while listing files via foundfiles

I am trying to list a group of files using foundfiles. I am interested
only in the file name, not the path ofr the extension. I can remove
the path by using the split function and a "\" as a delimiter. I then
take the upper bound of this to get "filename.ext". How can I get the
file name alone? I cannot use "." as a delimiter because some of my
files have "." in their file name. (eg. house.pic.summer.jpeg) Anyone
have any ideas?