Click to See Complete Forum and Search --> : get file name without extension


jrthor2
07-23-2003, 08:08 AM
I am using the following to get the first 3 leters of the file name, but I need to get the file name without the extension, Ex: baseball.gif, I need just baseball. Below is the code I am currently using. This is pulling the name from a lis of files in a directory.

img = (Left(rstFiles.Fields("name").Value, Len(rstFiles.Fields("name").Value) - InStrRev((rstFiles.Fields("name").Value), ".", -1, 1)))

jrthor2
07-23-2003, 08:32 AM
Thanks, you answered my question!!